Clear Sheet Activity
The Clear Sheet activity enables the removal of data from a specific Excel worksheet or a designated range within a sheet. It provides the flexibility to either wipe an entire page or target specific cell coordinates for data deletion.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | The reference name of the Excel file previously opened or created, selectable via a dropdown menu. | Required |
| Sheet Name | The specific name of the worksheet to be processed. If left blank, the activity targets the first sheet by default. | Optional |
| Range | The specific cell range within the worksheet from which data will be cleared. | Optional |
Action Types & Examples
Clear Entire Sheet
- Format: string
- Example Result: "Sheet1"
Clear Specific Range
- Format: string
- Example Result: "A1:C5"
Implementation Examples
Field Setup - Excel Name: ${newExcel} - Sheet Name: Sheet1 - Range: A1:C5
Execution Parameters - Target File Reference: ${newExcel} - Target Worksheet: Sheet1 - Target Area: A1:C5
Technical Notes
If a specific range is provided, only the data within those coordinates is removed. If the Range field is left empty, the activity deletes all content within the specified worksheet. Additionally, if the Sheet Name field is not populated, the activity will automatically execute on the first sheet of the Excel file.