Re: poi excel

Speaking of crashing the JVM, I've managed to do that several times (when
there were bugs in my RPG program). This has caused me to stop running
these things interactively because when the JVM crashes there, it never
comes back. After fixing the bug, you can't run the program again without
signing off/on. Running in batch is fine for my particular app, but what
if I had to run interactively?

Is there any way to reset the JVM after a crash?

Arthur J. Marino
Southern Container Corporation
(631) 297 - 2276



Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/24/2007 02:37 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: poi excel






After calling getCell() make sure you check to see if the cell object is
*NULL. That'll mean that there's no cell in that particular column of
that particular row (it shows up as an empty cell on the screen in
Excel, but it's not actually stored in the file, because it'd waste disk
space storing empty cells).

If you get a *NULL, it means that there'snothing there. You can add a
new cell using HSSFRow_CreateCell(), or my hssf_text(), hssf_num(), etc
shortcuts if you want to add a cell at that position.

If you're only trying to read existing cells, it should be safe to skip
anything that's *NULL.

If you try to refer to the cell object after it returns *NULL, you'll
end up crashing the JVM.



DLee@xxxxxxxx wrote:

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