Excel Worksheet Actions

• Retrieve information about the worksheets in an Excel file and place it into a new or existing variable; or

• Perform basic worksheet actions (rename, move, delete, etc.)

1. Select the Excel file on which you would like to perform a worksheet action.

2. Select the worksheet action you would like to perform:

   • Get worksheet name: Retrieve the name of the worksheet at a specified position.

   • Get worksheet position: Retrieve the position of the worksheet with a specified name.

   • Get worksheet count: Retrieve the total number of worksheets in the file.

   • Insert worksheet: Insert a blank worksheet in the specified position.

   • Move worksheet to another position: Move a worksheet from its currently specified position to a new position.

   • Duplicate worksheet: Duplicate the worksheet at the specified position.

   • Rename worksheet: Rename the worksheet at the specified position.

   • Delete worksheet: Delete the worksheet at the specified position.

3. Provide additional information as required (fields will vary by the worksheet action selected).

4. Instruct the wizard how to handle any errors encountered.

   Read more about error handling.

5. Enable timeout monitoring.

   Read more about Timeout Monitoring.