Clear Sheet Activity
The Clear Sheet activity deletes a specified page or a defined range within an Excel file. This activity provides flexibility to clear an entire sheet or a targeted section of data.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name of the Excel file which has already been opened or created. | Required |
| Sheet name | The name of the sheet to work in Excel. If not provided, the activity defaults to the first sheet. | Optional |
| Sheet index | The index of the sheet to work in Excel. If not provided, the activity defaults to the first sheet. | Optional |
| Range | The specific Excel sheet range from which to clear data. | Optional |
Action Types & Examples
Excel Name
- Format: string
- Example Result:
${newExcel}
Sheet Name
- Format: string
- Example Result:
Sheet1
Sheet Index
- Format: digit
- Example Result:
5
Range
- Format: string
- Example Result:
A1:C5
Implementation Examples
Field Setup - Excel name: ${newExcel} - Sheet name: Sheet1 - Sheet index: 5 - Range: A1:C5
Execution Parameters
Technical Notes
If a specific range is provided, the activity clears data only within that range. If no range is specified, the entire sheet is deleted. When processing the first sheet of an Excel file, the Sheet name and Sheet index fields are optional; otherwise, they must be configured.