Does anyone have a method to create a new sheet once you've exceeded the 65K
row limit in a sheet? I'm trying to run a 70,000 line report, and I want to
wrap the records into a new sheet.
Basically what I'm doing now is:
short rowNumber = 0;
HSSFRow r = mySheet.createRow(rowNumber);
while(rs.next())
{
//write cells in row
rowNumber++;
}
I figure I need to replace "rowNumber++" with a method to return the next
number or set "mySheet" to a new sheet and return 0 to start over, but I
can't figure out exactly how to do this.
Thanks in advance for any help,
Brian Glick
Freightek, Inc.
(215) 887-6100
[EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
