Do you need to manipulate the whole file at once? Maybe you could split it and open it by parts, like 1000 rows at a time? don't ask me how :) i have not tried it with poi, but that is how i would try to approach the problem. opening 65000 rows at once doesn't seem too efficient :)
-----Original Message----- From: "som kolli" <[EMAIL PROTECTED]> To: "'POI Users List'" <[EMAIL PROTECTED]> Date: Thu, 25 Sep 2003 16:31:17 -0400 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]
