How to write excel file into the specific sheet with the Report Generation Tool

[AGandhi]

I try to use the "excel easy title" to write some data into the excel file.

For the 1st sheet, there is no problem.

But how to write some data into other sheet, for example, the "sheet2"?

Seems that there is no such config option.

[Bob_Schor · Accepted solution]

It is actually much easier now.  Excel used to open with three WorkSheets, so you needed slightly different code to activate 2 and 3 than to simply make a new WorkSheet.  

Open the Report Generation Palette, open Excel Specific, and then open Excel General.  You either want Add Worksheet (which will ... Add a new WorkSheet, giving it a new name, and making it the Current Worksheet, or, if you already have unused WorkSheets in your WorkBook, you can choose Get WorkSheet, which makes one of the existing WorkSheets (assuming you have 3, you could "Get" Worksheet 1, which probably has the name "Sheet 2"), again making it the Current Worksheet.

Bob Schor

[AGandhi]

Solved!

Thank you for your quick and perfect answer!