Help Centre › Building Processes
Update the current row (in a loop).
Runs on: macOS and Windows only.
Add it to a process
In the process designer, open the Add step tab. Find Update row values under Excel › Rows, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| File path | No | Enter the file path, or use a variable such as {folders::desktop::path}\file.xlsx. Leave blank to use the workbook an earlier step opened. |
| Sheet | Yes | Name of the sheet in the Excel file. Supports wildcards: * matches any characters. |
| Keys | No | Column names to update, comma-separated. |
| Save after update | No | Save the workbook as soon as the row is updated, so a later failure cannot lose it Default: off. |
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
- Updates column values in the currently active row
- Use inside a loop to update rows one by one