XenoGuard 4.0 Documentation
Delete Sheet
ActionStep Reference » Windows » File Handling » Excel » Delete Sheet
The ActionStep Excel Delete Sheet removes a worksheet from an existing Excel file.
[-] Hide
- Open the Windows node in the Workspace Explorer.
- Open the File Handling node.
- In the Excel node, select the Delete Sheet ActionStep.
Parameters:
The ActionStep 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] |
|
The Sheet Name in an Excel file is listed as fixed values of the context scopes. |
Results:
The ActionStep 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 ActionStep 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