Set Formula Activity
The Set Formula activity replaces existing formulas within a specified cell or range in an Excel file. It modifies existing formulas and does not assign new formulas to cells that currently lack one.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | The reference name of the Excel file which has already been opened or created. Selected from a dropdown. | Required |
| Range | The specific cell or range of cells where the formula will be set. | Optional |
| Sheet Name | The name of the sheet to work within the Excel file. If not specified, the first sheet is used by default. | Optional |
| Sheet Index | The numerical index of the sheet to work within the Excel file. If not specified, the first sheet is used by default. | Optional |
| Formula | The Excel formula to be set, written without the leading '=' sign. | Required |
Action Types & Examples
Formula Replacement
- Format:
boolean - Example Result:
true
Implementation Examples
Field Setup - Excel Name: MyWorkbook - Range: A1:C5 - Sheet Name: SalesData - Sheet Index: 1 - Formula: SUM(B2:B10)
Execution Parameters - Excel Name: excelReferenceVariable - Range: dynamicRangeString - Sheet Name: currentSheet - Sheet Index: sheetNumber - Formula: calculatedFormula
Technical Notes
The Set Formula activity is specifically designed to replace existing formulas. It cannot be used to assign a new formula to a cell that currently does not contain one.