Remove Cell Style Activity
The Remove Cell Style activity enables users to clear formatting from specified cells within an Excel file. This activity targets existing Excel files and allows for precise control over which cells have their styles removed.
| 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 specified, the first sheet is used by default. | Optional |
| Sheet Index | The index of the sheet to work in Excel. If not specified, the first sheet is used by default. | Optional |
| Range | The range of cells from which to remove style. If not specified, all data in the Excel file constitutes the dataset range. | Optional |
Action Types & Examples
Remove Cell Style
- Format:
boolean - Example Result:
true
Implementation Examples
Field Setup - Excel Name: `${newExcel}` - Sheet Name: `Sheet1` - Sheet Index: `5` - Range: `A1:D7`
Execution Parameters
Technical Notes
The sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled. If the Range field is not filled, all of the data in the Excel file constitutes the dataset range.