On 25/05/12 06:58, Parag Joshi wrote:
I want to check whether given sheet (by name or number) exists in the file (xls
or xlsx) before I read it. I am using Event API to address memory footprint
issue and thus I don't want to use org.apache.poi.ss.usermodel.Workbook object.
Can someone please help me?
The way to check using the UserModel code is the same for the two formats.
However, you've asked about the Event API. These are much lower level,
so the differences between the two formats have to be handled by you as
there's nothing in between to hide them. (If you want an easy life, just
buy some more memory for your server and stick with the UserModel!)
For the .xls file format (HSSF), the details of the sheets are stored
near the top of the file. Start processing the file, and wait for the
BoundSheetRecord (sid=0x0085) to come past. When you've seen all of
those, you'll know if your sheet is in the file or not. If it is,
process as normal. If not, abort.
For the .xlsx file format (XSSF), open the file and grab the workbook
part (it's fairly small). Check that for what sheets exist, then decide
based on that if you want to process or not. If you're using XSSFReader,
call getWorkbookData() to get the Workbook part, then probably use
XmlBeans to process it.
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
