Please do not take this answer as being definitive Andreas as I have never used this API before - the event driven API that is. Logically though I cannot see that it would be possible to find out how many rows there are in the workbook as the API is processing it, so to speak, sequentially and cannot know this until it reaches the ened of the the file.
Having said that, I will try to find the time to have a quick dig around and post again if I find an answer. Yours Mark B Andreas Hartmann wrote: > > Hi everyone, > > I'm new to POI and started parsing Excel spreadsheets with the HSSF > event API, which works fine. > > But since I'm dealing with rather large files, I'd like to display a > progress bar to the user while the spreadsheet is parsed. > > Is there any way to determine the number of rows before the whole > document is parsed? > > Thanks a lot in advance! > > -- Andreas > > > -- > Andreas Hartmann, CTO > BeCompany GmbH > http://www.becompany.ch > Tel.: +41 (0) 43 818 57 01 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > > > -- View this message in context: http://www.nabble.com/Number-of-rows-with-HSSF-Event-API-tp24933683p24949515.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
