On Mon, 24 Oct 2011, ketan126 wrote:
I m using apache poi 3.7 jar and was stuck at one place while designing the
functionality, would require expert guidance on same.

I am reading excel using foll sample code
workbook = WorkbookFactory.create(new FileInputStream(fileName));

It's much more memory efficient to pass a File object rather than an inputstream. (You'll need to upgrade from 3.7 to get that though)

Is there any way to retrieve the same using Sheet object ,i had gone through org.apache.poi.ss.usermodel.Sheet class and was able to retrieve workbook object using Sheet class getWorkbook object but was not able to find a way to get Excel file name or excel file path.

Nope, instead simply pass the filename to your method along with the sheet

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to