Re: Reading XLS

Hello,

The HSSFWorkbook class has a getNumberOfSheets() method to tell you how many sheets it contains.

The HSSFSheet class has a getFirstRowNum() and getLastRowNum() to get the starting/ending row numbers. (Remember, rows do *not* have to start at 0, and there can be missing rows in the middle as well.)

The HSSFRow class has methods named getFirstRowNum() and getLastRowNum(). (Oddly, getLastRowNum() returns the highest row number + 1).. again, remember that cell numbers don't need to start
at 0, and there can be missing cells in the middle.

I personally do not use these methods, so I haven't prototyped them. You'll need to do that yourself.

You can find the JavaDocs for POI on Apache's web site, here:
http://poi.apache.org/apidocs/index.html



On 12/20/2011 10:21 AM, sjones@xxxxxxxxxxxxxxx wrote:

I am using HSSF to read a spreadsheet using:

row = HSSFSheet_getRow(sheet: RowIndex);
cell = HSSFRow_GetCell(row: ColIndex);

I increment RowIndex/ColIndex to move through the spreadsheet. How do I
determine when I have reached the end of the sheet? I tried chekcing row
for *null, but that didn't work.

Thanks

Steve Jones