XenoGuard 4.0 Documentation

Delete Cells

ActionStep Reference » Windows » File Handling » Excel » Delete Cells

The ActionStep Excel Delete Cells removes a specified cell range in the worksheet of an 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 Cells ActionStep.

Parameters:

The ActionStep has the following input parameters:


NAME DESCRIPTION
Path Name
Specifies the path of the Excel file.
Sheet Name
The name of the worksheet in the Excel file.
First Row
The number value of the starting row where cells will be deleted.
Last Row
The number value of the ending row where cells will be deleted.
First Column
The number value of the starting column where cells are to be deleted.
Last Column The number value of the ending column where cells are to be deleted.

Information

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

All values of the parameters are determined by the specified format.

Results:

The ActionStep returns the following results:


NAME
DESCRIPTION
Result
Confirms if the range of cells in the worksheet was successfully deleted or not.

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

Example 1 (Remove the last row in a worksheet):

This example takes out the last row in a specified worksheet of an Excel file after retrieving the row and column information with Get Sheet Information. If the last row is successfully deleted, the ActionStep in the "Then" branch is executed, otherwise the ActionStep in the "Else" branch is performed. A notice of the result is then output via Message Box.