title: How to load a large xlsx file with Apache POI?
body: <p>I have a large .xlsx file (141 MB, containing 293413 lines with 62 columns each)  I need to perform some operations within.</p>
  
  <p>I am having problems with loading this file (<code>OutOfMemoryError</code>), as POI has a large memory footprint on XSSF (xlsx) workbooks.</p>
  
  <p><a href="https://stackoverflow.com/questions/6069847/java-lang-outofmemoryerror-java-heap-space-while-reading-excel-with-apache-poi">This SO question</a> is similar, and the solution presented is to increase the VM's allocated/maximum memory.</p>
  
  <p>It seems to work for that kind of file-size (9MB), but for me, it just simply doesn't work even if a allocate all available system memory. (Well, it's no surprise considering the file is over 15 times larger)</p>
  
  <p>I'd like to know if there is any way to load the workbook in a way it won't consume all the memory, and yet, without doing the processing based (going into) the XSSF's underlying XML. (In other words, maintaining a puritan POI solution)</p>
  
  <p>If there isn't tough, you are welcome to say it ("There isn't.") and point me the ways to a "XML" solution.</p>