RE: Update a spreadsheet with data from iSeries (closed)

I think there's a difference between "empty" as we AS/400 people think of
it, and "empty" as PC software things of it. Blanks are not "empty" to a PC
app, typically. Perhaps that's the issue you're experiencing.

-Bob Cozzi
www.RPGxTools.com
If everything is under control, you are going too slow.
- Mario Andretti

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Leif Guldbrand
Sent: Saturday, June 25, 2005 12:27 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Update a spreadsheet with data from iSeries (closed)

FYI:

Problem saved. I ended up with the following code:

cell = HSSFRow_GetCell(Row:  85);                         
          if cell = *NULL;                                   
             cell = HSSFRow_createCell(Row:  85);            
             HSSFCell_setCellType(cell: CELL_TYPE_STRING);   
          endif;                                             
   TempStr = new_String(EU0086);                             
   HSSFCell_setCellValueStr(cell: TempStr);        

But it dont give me the answer why.... because lots of the other alpha cells
were empty too.... well.. I guess it's time to relax :-)

Thanks alot for the help.

Btw. the numeric 'right align' problem I have had, is ok now.

Best regards,
Leif

----- Original Message ----- 
From: "Scott Klement" <rpg400-l@xxxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: 24. juni 2005 21:04
Subject: Re: Update a spreadsheet with data from iSeries


> Hello,
> 
> >     cell = HSSFRow_GetCell(Row:  85);        <-------------ERROR
(cell=0)
> [SNIP]
> > Cell no. 85 returns with 0 (zero) which indicates 'no cell found'
> > and the program dumps in line 3 of the section.
> >
> > There is nothing wrong with cell no. 85 in the row as I can see.
> > All fields that gives the error is char. fields.
> 
> To conserve space, Excel will only include cells if they're not empty. The

> empty cells are not saved to the file.
> 
> Therefore, you may get this error when trying to update a cell that's 
> empty in your spreadsheet.  I suggest that you check it by coding 
> something like the following (untested):
> 
>      cell = HSSFRow_getCell(row: 85);
>      if cell = *NULL;
>          cell = HSSFRow_createCell(row: 85);
>      endif;
> 
> Good luck