You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Davinder Kohli <kd...@yahoo.com> on 2004/06/21 18:26:05 UTC
Problem inserting > 65K rows
I am trying to insert 65536 (Max rows an Excel Sheet
can hold) distinct rows from sql table to excel, but I
end up having 32868.
Debugging into the code, I found...
HSSFSheet.firstRow = -32768
HSSFSheet.lastRow = 32767
Both these variables are defined as int, so they
should be able to hold a value more than this.
Also, the modCount of the TreeMap = 32868.
BTW, when I could move 32676 rows table without any
problem, I haven't found the threshold where it fails.
Any idea what's going on here? I will continue
debugging into POI.
Thanks,
Davinder
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Problem inserting > 65K rows
Posted by Davinder Kohli <kd...@yahoo.com>.
I upgraded from POI 1.5 to 2.5 and did not update my
API for createRow() which used to take short and now
it takes int as rowNum. After I did this, I was able
to get rid of the problem.
--- Davinder Kohli <kd...@yahoo.com> wrote:
> I am trying to insert 65536 (Max rows an Excel Sheet
> can hold) distinct rows from sql table to excel, but
> I
> end up having 32868.
>
> Debugging into the code, I found...
> HSSFSheet.firstRow = -32768
> HSSFSheet.lastRow = 32767
>
> Both these variables are defined as int, so they
> should be able to hold a value more than this.
>
> Also, the modCount of the TreeMap = 32868.
>
> BTW, when I could move 32676 rows table without any
> problem, I haven't found the threshold where it
> fails.
>
> Any idea what's going on here? I will continue
> debugging into POI.
>
> Thanks,
> Davinder
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We
> finish.
> http://promotions.yahoo.com/new_mail
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> poi-user-help@jakarta.apache.org
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org