Apache POI Question

[Si]

I'm parsing an MS Excel spreadsheet using the POI HSSF event api, as this is
reportedly much faster than reading the entire sheet in as a HSSFSheet
object.

This works well but still takes a long time so I want to give the user some
feedback on progress. However I can't seem to find a good way of knowing how
large the spreadsheet is going to be and how far through it I am at any one
point.

If anyone has experience of using this api and can help I'd very much
appreciate it.

Thanks,

Simon

 

[TechBookReport]

I'm parsing an MS Excel spreadsheet using the POI HSSF event api, as this is
reportedly much faster than reading the entire sheet in as a HSSFSheet
object.

This works well but still takes a long time so I want to give the user some
feedback on progress. However I can't seem to find a good way of knowing how
large the spreadsheet is going to be and how far through it I am at any one
point.

If anyone has experience of using this api and can help I'd very much
appreciate it.

Thanks,

Simon

Use the Excel object model to get the number of worksheets in the
workbook. For each worksheet you can try using the UsedRows property to
get some idea - though it depends on the dimensions of your sheets.

Pan
===========================================
TechBookReport - http://www.techbookreport.com