In a sheet containing 65536 rows, I invoked removeRow,
after all rows were removed the lastRowNum and
firstRowNum were both set to -1. Shouldn't both these
be set to 0?
HSSFSheet sheet = m_workbook.getSheet(sheetName);
// get the last row num
int lastRowNum = sheet.getLastRowNum();
// lastRowNum returns 65535
for (int i = 0; i < lastRowNum +1; i++)
{
// get the row and remove it
sheet.removeRow(sheet.getRow(i));
}
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
