EXCEL Add a row function

The EXCEL Add a row function in RPA.

Help CentreBuilding Processes

This article describes the RPA Excel functionality to add a row.

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


Description

The EXCEL Add a row function allows you to add a row.


Setting it up

To use the EXCEL Add a row function, follow these instructions:

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

Once on a process map:

  1. Navigate to the process where you would like to add the EXCEL Add a row 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 Add a row option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
File pathYesTextFull path to the Excel file.
SheetYesTextName of the target sheet.
RowNoNumberRow position to insert at (0–65536). Inserts at the end if omitted.

Output variables

This action does not produce any output variables.


Errors

ErrorDescription
Sheet not foundThe specified sheet does not exist.

Tips

  • Omit the row number to append a new row at the bottom of the data.

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.