This content has been marked as final. Show 4 replies
Looks like a bug in jxl.
Hi, Thanks for the reply. Do you know any other API i can use to read large sized excel file. I tried with org.apache.poi's HSSFWorkBook m facing the
java.lang.OutOfMemoryError: Java heap space with this. I Increased the heap size by setting my VM arguments to "-Xms512m -Xmx1024m".
I have no knowledge of either library, but something pops to mind:
java.lang.OutOfMemoryErrorThat may be due to the library trying to load the whole file in memory.
That may or may not be necessary (depending on what you need to do with the contents).
If it's not necessary (e.g., you're just looking for a given row in a plain old rowXcolumn matrix), you may either search the libaries doc for a way to read the file in chunks, or write your own routine (e.g. manually save the XLS to CSV format, then run your program ro read and parse each line individually).