Summary: | Unable to read large excel file | ||
---|---|---|---|
Product: | POI | Reporter: | Nirupam <nirupamind> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | major | ||
Priority: | P3 | ||
Version: | 1.0.2 | ||
Target Milestone: | --- | ||
Hardware: | HP | ||
OS: | All |
Description
Nirupam
2004-02-24 02:13:41 UTC
HSSF is a memory hog. This is known. You can either increase the heap size or for your application you may want to consider using the HSSF event model instead of reading in the entire workbook. See http://jakarta.apache.org/poi/faq.html#faq-N10011 also http://jakarta.apache.org/poi/hssf/how-to.html in the event model part Please upgrade to POI 2.0 though. Jason It seems HSSF works with small mb of excel , but when 10 mb of file is under processing ,the request is hung. Can any body suggest any alternative for this. Will Jexcel solve the problem ? do any body have implemented? |