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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
