what's the maximum excel file size supported?
Hi, I'm using UserModel package of HSSF to access an excel file. I would like to know the maximum size this package supports, since if I'm giving files greater than 2 mb, then I'm getting the error java.lang.OutOfMemoryError. Any sugestion or info in this regard would be helpful. Thanks in advance. Ravi -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: OutOfMemoryError while reading excel file
No, you must start the jvm with -Xmx{size}m Generally distribute your application with a run.bat and run.sh file. Other successful programs that do this: 1. Tomcat 2. JBuilder 3. Netbeans -Andy On Sat, 2002-06-22 at 03:32, Ravi S Kodamarti wrote: Hi, I'm getting OutOfMemoryError while reading an excel file. In one of the previous postings (for writing into an excel file), I saw that, if we increase the JVM heap size, then the OutOfMemory error problem would be solved. But, I have a concern here.. If we run the application in client-server environment, then what would be the turn around for the problem? Is there any way to increase the heap size programmatically? Thanks in advance. Ravi. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
WARNING JAVA GUI (yuck!) -- Announcing SuckyViewer 0.10 for XLSfiles
Hi All, Don't ask my why I did this... but maybe it has to do with the umpteenth private email asking me if HSSF has a gui app to show XLS files. I wrote this in the course of about an hour. Its in contrib, it reads XLS files from streams and/or files, it can run as an applet. It proves I'm the worlds greatest Java Gui programmer ;-).. Its called SUCKY VIEWER 0.10. And it is true to its name, but it works. Features: 1. Runs as an applet 2. Reads and renders XLS files using the HSSF usermodel 3. Can take a filename or url applet parameter and will read it from the local or remote system 4. Renders all major data types, Strings, Numbers, etc. 5. sets cell background color if its set with pattern type SOLID_FOREGROUND (1) 6. sets the font if java.awt.Font knows what to do. Contribution opportunities (for YOU not ME): 1. No borders 2. No alternative Patterns for fill types 3. Doesn't mess with HSSFCellFormat (meaning numbers are nasty looking) 4. Renders so slow my grandma could outrun it. (hint: the getRow, getCell methods are NOT fast) 5. Using a URL instead of a filename when its run as an application and not an applet doesn't seem to work (oops, sorry) 6. Did I mention I put very little effort into this? So if someone improves this to not Suck, I'll rename it ;-) and perhaps move it to www.krysalis.org Happy Hacking. -Andy -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: WARNING JAVA GUI (yuck!) -- Announcing SuckyViewer 0.10 for XLSfiles
oh its in the head under jakarta-poi/src/contrib/src/org/apache/poi/hssf/contrib/view you can build it by running ./build.sh contrib suckyviewer /home/andy/myxls.xls If you jar it up and make it in an applet be sure you set the filename OR the url property. -Andy On Sat, 2002-06-22 at 12:08, Andrew C. Oliver wrote: Hi All, Don't ask my why I did this... but maybe it has to do with the umpteenth private email asking me if HSSF has a gui app to show XLS files. I wrote this in the course of about an hour. Its in contrib, it reads XLS files from streams and/or files, it can run as an applet. It proves I'm the worlds greatest Java Gui programmer ;-).. Its called SUCKY VIEWER 0.10. And it is true to its name, but it works. Features: 1. Runs as an applet 2. Reads and renders XLS files using the HSSF usermodel 3. Can take a filename or url applet parameter and will read it from the local or remote system 4. Renders all major data types, Strings, Numbers, etc. 5. sets cell background color if its set with pattern type SOLID_FOREGROUND (1) 6. sets the font if java.awt.Font knows what to do. Contribution opportunities (for YOU not ME): 1. No borders 2. No alternative Patterns for fill types 3. Doesn't mess with HSSFCellFormat (meaning numbers are nasty looking) 4. Renders so slow my grandma could outrun it. (hint: the getRow, getCell methods are NOT fast) 5. Using a URL instead of a filename when its run as an application and not an applet doesn't seem to work (oops, sorry) 6. Did I mention I put very little effort into this? So if someone improves this to not Suck, I'll rename it ;-) and perhaps move it to www.krysalis.org Happy Hacking. -Andy -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]