A good rule of thumb seems to be that you need about 64 MB + 10 x the size of the .xls file you are trying to read. At least that works for me.
-----Original Message----- From: som kolli [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 4:31 PM To: 'POI Users List' Subject: RE: Ugent Help required, Excel sheet Max limit -- POI Brook, Thanks very much for the help, it works fine... Iam was able to open the excel sheet... there is issue here, Can I specify the memory for a class permanently...., what is happening is everytime I compile the java file, I have to do Java -xms6m -xmx180m uploadExcel, otherwise it is throwing me outofmemory exception... thanks Som -----Original Message----- From: Brook Stevens [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:44 PM To: 'POI Users List' Subject: RE: Ugent Help required, Excel sheet Max limit -- POI Your probably just running out of memory to the JVM, try increasing the memory you give when you start your program: java -Xms<min_size> -Xmx<max_size> I do believe hearing in some previous thread that there is a theoretical max size, but it may have been changed, and I am not even a 100% sure of that. Excel itself does have a max size although I don't remember what it is. Either way I think you are within the limits. -Brook > -----Original Message----- > From: som kolli [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 25, 2003 3:44 PM > To: 'POI Users List' > Subject: Ugent Help required, Excel sheet Max limit -- POI > > > hi all, > > What is the max.limit (rows) an excel can have so that POI can open it > without any problems... > > I have an excel of 36,000 rows and 15 columns.., Iam getting > java.lang.outOfMemory error when I try to open it using POI... can you > please help me out on the same > > regards > Som > > > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
