The Add Worksheet action is used to add a worksheet to an existing workbook in an open Excel session. An Excel session must be created in an earlier step using the Open Workbook or Create Workbook actions. You can select from various sheet types and can elect to add the worksheet before the currently active sheet or at the end.
Note: You must have Microsoft Excel licensed and installed on your system to use any of the AutoMate Excel actions.
From the Task Builder Available Actions pane, open the Excel folder and double-click the Add Worksheet action or drag it into the Steps pane.
In the Session name box, enter the session name. If your task has only one Excel session and you did not change the default session name when you created it (recommended), you can use the default entry.
In the Worksheet name box, enter the name for the new worksheet.
Select Insert worksheet before active one, or Add worksheet at end.
In the Sheet type box, select the type of sheet to add. If you select Specific template, use the Open Folder button to enter the template in the box below.
To set the Description tab properties, refer to Description Tab Options.
To set the Error Causes and On Error tab properties, refer to Step Error Handling.
When finished, click OK to save settings and close the properties dialog window.
Adding Task Steps
Add Worksheet Action