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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.