XenoGuard Documentation

Delete Sheet

Actions » Windows » File Handling » Excel » Delete Sheet

The action Delete Sheet removes a worksheet from an existing Excel file.

[-] Hide
  1. Open the Windows node in the Workspace Explorer.
  2. Open the File Handling node.
  3. In the Excel node, select the Delete Sheet action.


The action has the following input parameters:

Specifies the Excel File where the worksheet is to be deleted.

Allowed Context Scopes
 [Fixed, Local, Global]
Allowed Context Types
 [Variable, Parameter, Enum] 
Sheet Name
The worksheet name to be deleted from the Excel file.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]

Information The Sheet Name in an Excel file is listed as fixed values of the context scopes.


The action returns the following results:

Confirms if the worksheet was successfully added or not.

Allowed Context Scope [Fixed]
Allowed Data Type [Boolean]

Example 1 (Remove an empty worksheet):

This example deletes an empty worksheet only after checking the contents and confirmation of the action to be performed. A notice is displayed after successfully deleting the worksheet via Message Box.

See other Excel operations:

Create File
Get Sheet Information
Add Sheet
Rename Sheet
Insert Data
Update Data
Get Data
Format Cells
Clear Cells
Delete Cells