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