java.lang.OutOfMemoryError: Java heap space while reading excel with Apache POI

by

First thing to check – are you opening the XSSFWorkbook with an InputStream or a File? Opening it with a File is much lower memory.

Next up, do you want to read or write? If memory is very tight for you, there are alternate options for using XSSF in a sax like way.

For reading, see http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api for details of using XSSF + Sax. As another option, if you just want to get the textual content of the file, then it looks like Apache Tika has an event based text extractor for .xlsx files using POI.

For writing, there has been lots of discussions on the POI dev list recently about improving the “Big Grid Demo”. You might want to follow those – http://poi.apache.org/mailinglists.html

More Related Contents:

  1. How to load a large xlsx file with Apache POI?
  2. Apache POI error loading XSSFWorkbook class
  3. How to read Excel cell having Date with Apache POI?
  4. Docx to Pdf Converter in java
  5. Apache POI – FileInputStream works, File object fails (NullPointerException)
  6. Apache poi Excel line chart points
  7. How to set axis’ labels in a Line Chart using Apache Poi
  8. Cannot import XSSF in Apache POI
  9. Removing a row from an Excel sheet with Apache POI HSSF
  10. Apache POI autoSizeColumn Resizes Incorrectly
  11. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  12. How to get an Excel Blank Cell Value in Apache POI?
  13. Basic Excel currency format with Apache POI
  14. Password Protected Excel File
  15. Get the cell value as how it was presented in excel
  16. Apache POI Streaming (SXSSF) for Reading
  17. Exception when writing to the xlsx document several times using apache poi 3.7
  18. How to Cache InputStream for Multiple Use
  19. Apache-POI sorting rows in excel
  20. Creating a Table of Contents for a XWPFDocument with page numbers’ indication
  21. Java POI : How to read Excel cell value and not the formula computing it?
  22. How to convert HSSFWorkbook to XSSFWorkbook using Apache POI?
  23. Convert Word to HTML with Apache POI
  24. apache POI java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile
  25. How can I change charts generated by apache poi to not use smoothed lines and show empty cells as gaps?
  26. Java POI the supplied data appears to be in the Office 2007+ XML
  27. Determine MS Excel file type with Apache POI
  28. Limitation while generating excel drop down list with Apache POI
  29. Reading data from xlsx with Apache POI’s SXSSFSheet
  30. POI DataFormatter returns 2 digits year instead of 4 digits year for date cells [duplicate]

Leave a Comment