Excel: Update row values

Update the current row (in a loop).

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

FieldRequiredWhat it does
File pathNoEnter the file path, or use a variable such as {folders::desktop::path}\file.xlsx. Leave blank to use the workbook an earlier step opened.
SheetYesName of the sheet in the Excel file. Supports wildcards: * matches any characters.
KeysNoColumn names to update, comma-separated.
Save after updateNoSave the workbook as soon as the row is updated, so a later failure cannot lose it Default: off.

See all Excel steps.

Errors

ErrorDescription
File not openThe Excel file must be open
Sheet not foundThe specified sheet does not exist

Tips

  • Updates column values in the currently active row
  • Use inside a loop to update rows one by one

Related functions

Get started

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or have your first automation working in 7 days.