You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by sivabharathi <si...@originwave.com> on 2011/04/21 12:21:28 UTC
poi 3.6 version Export excel 2007 Format
Hi,
I am using Poi 3.6 version and excel 2007 format. I trying to export more than
5 lacs data. But i am not getting the result in single excel file. Actually
excel 2007 support more than 10 lacs, But i am getting only 1,47,253 records in
a single excel file after that it's not insert the data into the excel. I don't
know where problem occurs.
I tried in another way also, that is insert 1 lac record each excel sheet (one
file more than one sheet)like that. That time also i am getting same record
count. 1st sheet : 1 lacs and 2nd sheet: 47,000 records.
How i can solve this problem. I tried poi 3.8 beta 2 version also. But not yet
the get output.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: poi 3.6 version Export excel 2007 Format
Posted by ssivabharathi <ss...@gmail.com>.
Hi,
Thank you for your reply. it's 100,000 only. How i can do that.
I trying to use biggriddemo.java like a program. In that how i can get the
row number (getRow). other wise how i can update the row?
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/poi-3-6-version-Export-excel-2007-Format-tp4330449p4331424.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: poi 3.6 version Export excel 2007 Format
Posted by JOSE L MARTINEZ-AVIAL <jl...@gmail.com>.
For those who don't know, lac is an indian numbering term that means
100,000.
2011/4/21 sivabharathi <si...@originwave.com>
> Hi,
> I am using Poi 3.6 version and excel 2007 format. I trying to export more
> than
> 5 lacs data. But i am not getting the result in single excel file. Actually
> excel 2007 support more than 10 lacs, But i am getting only 1,47,253
> records in
> a single excel file after that it's not insert the data into the excel. I
> don't
> know where problem occurs.
>
> I tried in another way also, that is insert 1 lac record each excel sheet
> (one
> file more than one sheet)like that. That time also i am getting same record
> count. 1st sheet : 1 lacs and 2nd sheet: 47,000 records.
>
> How i can solve this problem. I tried poi 3.8 beta 2 version also. But not
> yet
> the get output.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>