sheet.fillRange
Fill spreadsheet ranges with formula patterns using {row} and {col} placeholders to efficiently compute columns or rows in Circuitry workflows.
Instructions
Fill a range with a formula pattern - efficient for computed columns/rows. Use {row} for 1-indexed row number (Excel-style), {col} for column letter.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| nodeId | Yes | Sheet node ID or name | |
| formula | Yes | Formula pattern with {row}/{col} placeholders (e.g., "=A{row}*B{row}") | |
| col | No | Column index for vertical fill (0-indexed) | |
| startRow | No | Start row (0-indexed, defaults to 0) | |
| endRow | No | End row (0-indexed, defaults to last row) | |
| row | No | Row index for horizontal fill (0-indexed) | |
| startCol | No | Start column for horizontal fill (0-indexed) | |
| endCol | No | End column for horizontal fill (0-indexed) |