Set Formula Activity
The Set Formula activity replaces existing formulas within a specified cell or range in an MS Excel file. This activity is designed to modify existing formulas and cannot be used to assign new formulas to cells that do not already contain one.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name of the Excel file that has already been opened or created. | Required |
| Range | The range of cells where the formula will be applied. | Optional |
| Sheet name | The name of the sheet to work within the MS Excel file. If not specified, the first sheet is used by default. | Optional |
| Sheet index | The index of the sheet to work within the MS Excel file. If not specified, the first sheet is used by default. | Optional |
| Formula | The Excel formula to be set, written without the leading ‘=’. | Optional |
Action Types & Examples
Set Formula Operation
- Format: Modifies an existing Excel cell's formula.
- Example Result: The specified cell or range in the Excel file is updated with the new formula.
Implementation Examples
Field Setup - Excel name: ${newExcel} - Range: A1 - Range: A1:C5 - Sheet name: Sheet1 - Sheet index: 5 - Formula: SUM(A1:B1)
Execution Parameters - No distinct execution parameter examples are provided for this activity.
Technical Notes
If there is no formula in the cell, it cannot be used for new formula assignment.