Re: Writing from RPGLE to Excel - using a formula on one worksheet to reference data on another worksheet

Yes, the summary worksheet already exists.  I'm using a "prototype"
worksheet, not building one from scratch.

After I write detail to the previous worksheet, I process this code:
       sheet = hssf_getSheet(book: 'Summary');

      ExSr $CellSummary;

Then,
      BegSr $CellSummary;

      CurRow   = 8;
      CurCell  = 6;
      hssf_formula( row: CurCell: 'SUM('+StartCellCR+':'+EndCellCR+')':
Value);

This is being written in the previous worksheet (with the correct range),
not the current (Summary) worksheet.  At this time I have not qualified the
range with the worksheet name.

Ah, I see my problem.  I don't retrieve a record before I write to the 2nd
worksheet, so my program doesn't know to write to a different worksheet.  I
thought it would be something simple I was overlooking.

Thanks much!
Mark Plank

On 1/23/07, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx> wrote:

The way your code is written, it'll only work if the 'Summary' sheet
already exists in the document.  Is that the case?

You say that when you write the new cell, it appears on the wrong sheet.
Can you show us the code that writes the new cell?  Since that's where the
problem is happening?

I'd also run the code in debug -- make sure that the number that's
returned by hssf_getSheet(book: 'Summary') is the same number that you
pass when you retrieve/add the row object that's being written to the
wrong sheet.