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.

Parameters:

The action has the following input parameters:


NAME DESCRIPTION
File
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.

Results:

The action returns the following results:


NAME
DESCRIPTION
Result
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