I believe that increase the heap for Eclipse, not for the JVM that Eclipse runs when running/debugging a program. Depending on how your launching your app, you may need to specify it elsewhere. For example, in the Run or Debug dialog, add the -Xmx option to the VM Args field.
-Russ -----Original Message----- From: Andy Ch [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 2:34 PM To: [email protected] Subject: Re: identify excel sheet in eventusermodel > Are you aware that you can increase the heap size java uses? Just pass > -Xmx to java (java -X gives you full details) i use eclipse as IDE attmpeted to play with 2 memory settings below, given maxmium i can (512mb and 1g) the excel file i am trying to open is about 25mb. is this normal? to put in context here's a link to explain what the following command does. it should be the same with what you proposed http://wiki.eclipse.org/FAQ_How_do_I_increase_the_heap_size_available_to _Eclipse%3F http://wiki.eclipse.org/FAQ_How_do_I_increase_the_heap_size_available_to _Eclipse%3F eclipse -vmargs -XX:MaxPermSize=<memory size> eclipse -vmargs -Xmx<memory size> > 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 could you be more specific at what you mean by "sheet start record", i dumped out "BoundSheetRecord" however these appears to be the indices only and they get dumped out first before any of the data cell did. which makes it not possible to infer sheet name of a given cell based on the sequence they are listed. also i reviewed the api (specifically org.apache.poi.hssf.record ) and did not find the sheet start record similar to what you proposed. (dump code is the same as on the poi example page posted earlier). api here http://poi.apache.org/apidocs/index.html http://poi.apache.org/apidocs/index.html dump sample ================= New sheet named: Sheet1 New sheet named: Sheet2 New sheet named: Sheet3 New sheet named: Sheet4 String table value 0 = Value1 String table value 1 = Value2 String table value 2 = Value3 String table value 3 = Value4 -- View this message in context: http://www.nabble.com/identify-excel-sheet-in-eventusermodel-tp16182268p 16185818.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
