Definition and Usage
The Write to cell command is used to update or set the value of a specific cell in a data table.
Parameters Values
Set parameters
Parameters | Description |
Data table | Select a data table that has been imported to RPA |
Row | Please enter a row number(Non-zero integers). Negative numbers are also supported, e.g. -N represents the Nth row counted from the end. |
Column | Please enter a column name or number(Non-zero integers). Negative numbers are also supported, e.g. -N represents the Nth column counted from the end. |
Write cell content | Enter the content to write to the cell |
Error handling
Parameters | Description |
When error occurs | If an error occurs, the process is terminated by default. You can also ignore the error or retry the current command |
Example
This workflow will import data from Sheet 1 of the Excel form and write the content "Title" to the cell located in row 1 and column 1.
Note: A target data table must be designated to use the Write to cell command. This data table can either be imported using the Import from Excel Worksheet command or generated in the previous workflow as a variant.