@Krishna_kp wrote:
yes, i'm writing an excel .xls file
The "Revised Generate Excel Report Example" I tried to point you to in my previous response shows how to Generate an Excel Report using the Report Generation Toolkit, but starting "from scratch". However, if you want to append to the end of an existing Excel WorkSheet, the process is not that difficult.
There are two parts to doing this, neither especially well-documented. The first is to specify the existing Excel WorkBook File (.xls or .xlsx) as the "Template" input to the New Report function. When you do this, it will (by default) open to the first WorkSheet in your Report ("Sheet 1" if you didn't name your sheets), and will be in Cell A1. If you now start saving, you will (probably) overwrite data that are already present, which you probably do not want to do.
In most cases, your WorkSheet is filled by rows of data. There is a function on the Report, Excel Specific, Excel General palette called Excel Get Last Row -- I think (but you can, and should, do a simple test to verify this) this gives you the Last Row with data present, so you want to start appending with the next row. Look at the Revised Example, Step 10, to see how to Move down 1 row.
Bob Schor
