Re: Reading Massive Excel Files to csv

On Mon, 3 May 2021, Oscar Bastidas wrote:
> 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."

That file has moved to
https://svn.apache.org/repos/asf/poi/trunk/poi-examples/src/main/java/org/apache/poi/examples/xssf/eventusermodel/XLSX2CSV.java

We have re-organised the svn area as part of our move to Gradle as our 
build system, and not all the links have been updated yet

Nick