On Thu, 20 Mar 2008, Andy Ch wrote:
i am reading a large excel file which the usermodel does not support (got the infamous out of heap memory)
Are you aware that you can increase the heap size java uses? Just pass -Xmx to java (java -X gives you full details)
which forces me to use the eventusermodel. after digging the api, and example i find no way of identifying which sheet the record come from (even though the row/col can be identified by getters supplied).
If memory serves correct, you need to keep track of the sheet start records as they go past. All the cells for a given sheet go together, so they'll belong to the most recent sheet you've seen
(Sheet names etc are defined seperately from where their data comes) Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
