EXCEL Update row values (in a loop) function

The EXCEL Update row values (in a loop) function in RPA.

Help CentreBuilding Processes

This article describes the RPA Excel functionality to update row values (in a loop).

For a full list of available functions, please read EXCEL functions.


Description

The EXCEL Update row values (in a loop) function allows you to update row values (in a loop).


Setting it up

To use the EXCEL Update row values (in a loop) function, follow these instructions:

{{popups:rpas/add:action=excel-update-row}}

Once on a process map:

  1. Navigate to the process where you would like to add the EXCEL Update row values (in a loop) function
  2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
  3. On the menu that appears, click on the “+ Activity” item
  4. From here you can select the EXCEL Update row values (in a loop) option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
SheetYesText-The name of the sheet
Column / Value pairsYesTable-Column names and their new values

Output variables

This action does not produce output variables.


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

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.