Re: Reading Massive Excel Files to csv

Thanks Nick for the updated link.

With your comment on moving to Gradle, does this mean there will be a time
when Apache POI will not be available on Maven?

Thanks again.

Oscar

Oscar Bastidas
Research Associate
University of Minnesota

On Mon, May 3, 2021, 6:17 AM Nick Burch <[email protected]> wrote:

> 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]
>
>