Autofill Activity
The Autofill activity copies the formula or content of a source cell range into an adjacent fill range, extending it automatically the way Excel's fill handle does. This is useful when a formula in one cell needs to be applied down a column or across a row without repeating the Set Formula activity for every cell.
| Field | Description | Requirement |
|---|---|---|
| Excel name | Specifies the reference name of the Excel instance to be modified. | Required |
| Sheet name | Defines the name of the worksheet containing the source and fill ranges. Defaults to the active sheet if left blank. | Optional |
| Source range | The cell or range containing the formula or value to copy (e.g., C1). | Required |
| Fill range | The destination range that the source content will be extended into (e.g., C1:C9). | Required |
Action Types & Examples
Formula Autofill
- Format: string
- Example Result: The formula in
C1is filled down throughC9.
Implementation Examples
Field Setup - Excel name: ${newExcel} - Sheet name: Sheet1 - Source range: C1 - Fill range: C1:C9
Technical Notes
The
Fill rangeshould include theSource rangeitself as its starting cell. Cell references within the source formula are adjusted automatically for each row or column in the fill range, matching native Excel autofill behavior.