How can i read a large excel file using POI?

[José Roberto Rodrigues dos Santos <jr...@gmail.com>]

Hi,
  I need to read a excel file data to export it to a mysql database, but i
am facing memory issues...someone has an example to read largest excel
files?
My excel file has 59 columns and more than 80000 rows...

Thanks a lot to all....

-- 
"*O que me preocupa não é o grito dos maus.
É o silêncio dos bons*." - *Martin Luther King*

Re: How can i read a large excel file using POI?

[kothaaja <ko...@gmail.com>]

Yegor,
Currently we are using usermodel for xls and xlsx  extensions,does it have
any advantages if we move to
eventuser model?Is there any way we can reach the large xl files in chunks.
Please let me know.

Thanks a lot to every one.


--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-can-i-read-a-large-excel-file-using-POI-tp5710061p5710398.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: How can i read a large excel file using POI?

[Yegor Kozlov <ye...@dinom.ru>]

You want to use the Spreadsheet Event API, see
http://poi.apache.org/spreadsheet/how-to.html

On Thu, Jun 7, 2012 at 3:44 AM, José Roberto Rodrigues dos Santos
<jr...@gmail.com> wrote:
> Hi,
>  I need to read a excel file data to export it to a mysql database, but i
> am facing memory issues...someone has an example to read largest excel
> files?
> My excel file has 59 columns and more than 80000 rows...
>
> Thanks a lot to all....
>
> --
> "*O que me preocupa não é o grito dos maus.
> É o silêncio dos bons*." - *Martin Luther King*

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org