Omershah,
You describe making a multi-sheet Excel Workbook. Here's a question for you -- is there a "standard form" for the WorkBook, i.e. it always has a WorkSheet called "Header", "Test 1", "Test 2", and "Test 3"? Or does it have a more "flexible" design, say a Header Worksheet and then N "Test" Worksheets (called "Test 1", "Test 2", etc.)?
In the first case where the format is fixed, you can create a "dummy" (or "Template") Workbook (call it "Dummy.xlsx") with Header, Test 1, etc. WorkSheets. You open Excel specifying Dummy.xlsx as the Template. You use the Excel Get Worksheet function, specifying the name of the Worksheet you want (e.g. "Header"), write data to it, then get Test 1, write more data, etc. When you are done, you save the Worksheet using a different name (so you can reuse the Template).
In the second case, you pretty much need to create each Worksheet "from scratch". Excel, by default, gives you three when you open it, called Sheet 1, Sheet 2, and Sheet 3. Select a Sheet, put whatever data you want on it, select another sheet, put more data, and if you run out of Sheets, use the Excel Add Worksheet to create more of them. When you are done, name and save the Workbook.
All of this assumes you have access to the Report Generation Toolkit, which has all those nice functions that Gregory showed you and that I described here.
Bob Schor
