Help Centre › Building Processes
Change all column values to a specific value, row by row.
Runs on: macOS and Windows only.
Add it to a process
In the process designer, open the Add step tab. Find Change column values under Excel › Columns, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Sheet | Yes | Name of the sheet in the Excel file. Supports wildcards: * matches any characters. |
| Keys | No | Comma-separated list of keys or column names |
See all Excel steps.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
Tips
- Use this to write values to specific columns in the current row