Reading Massive Excel Files to csv
Oscar Bastidas <[email protected]>
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <CAAXyaU3iD=xBd=MhLaqKonXYmwz78mF_Lvu1awDr4K2V8xgLPA@mail.gmail.com> |
Hello, I am trying to read a large Excel spreadsheet (60,000 rows) but I get what appears to be a memory leak error from the JVM when I use the *XSSFWorkbook *API. I learned recently that there are size limitations on Excel files being read in this way and the Apache POI website specifically recommends reading the file in a streaming fashion instead of taking the whole file in memory. To do this, POI recommends using something called *XLSX2CSV* but the provided link to teach how to use this returns a "page not found error." Would someone please point me in the direction of how to handle reading my big Excel file? The Apache POI URL that contains the link to *XLSX2CSV* is: http://poi.apache.org/components/spreadsheet/limitations.html Thanks for any help anyone can provide. Oscar Oscar Bastidas Research Associate University of Minnesota