poi excel

Morning all;

poi excel problem, evidentally I'm not understanding whats going on here.
I'm trying to loop thru the cells on row zero to copy those cells to
another sheet.

I used getlastcellnum to determine the last cell (lcellno) = 47 as a
short.

rowcount = 0;
x = 0; defined as int
row = HSSFSheet_getRow(sheet:rowcount);
lcellno = HSSFRow_getLastCellNum(row);

dow x <= lcellno;
cell = HSSFRow_GetCell(row: x ); resolves to 0 for cell 9
type = HSSFCell_getCellType(cell); resolves to 0

but when x = 9, cell value is 0, and blows up on th getStringCellValue.
my confusion is why cell value is zero, when row is 0, and x is 9. Could
it be null, if so how do I tell.

when type = CELL_TYPE_BLANK;
StrVal += String_getBytes(HSSFCell_getStringCellValue(cell));
hssf_text ( rowo : y :StrVal: Text);

Also, everytime it blows up, I have to signoff and sign back on to do a
retest. I don't understand that.

Appreciate any help


Darrell Lee
Information Technology
Extension 7127