http://nagoya.apache.org/wiki/apachewiki.cgi?POIBugReport
Amitabh Verma wrote:
Hi there,
I m using poi to read and append to mid size excel
files(around 2 MB) containing several sheets.
The following is the part of the code I use.
----------------------------------
for ( j =3;j<500; j++)
{
rowx = sheet.getRow(j);
if (rowx ==null) continue;
cell = rowx.getCell((short)6);
if (cell!=null) {
yyy = cell.getStringCellValue(); -- some processing --
}
}
---------------------------------------
After around 30th row the "rowx = sheet.getRow(j)"
returns a null through I can see in the file that the
row is populated.
Now when create another XL file(which has 2 sheets in
all) by copying the same sheet it works fine.
Has any one faced this before.
Thanx and Regards
Amitabh
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
