Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAExcel

Set value of a cell

Set value of a cell

Sets or updates the value of a specific cell in a tab of an Excel file.


Options​

Excel tab​

Select or enter the Excel tab where the information will be entered.

Column to enter the information​

Enter the letter of the cell's column, for example D.

Fill in the last cell of the column?​

Option to select Yes or No. When set to Yes, the row field is hidden and the value is entered in the first empty row after the column's last filled cell.

Line to enter the information​

Enter the number of the cell's row, for example 2. This field is shown only when Fill in the last cell of the column? is set to No.

Value type​

Select what will be entered in the cell: Valor (shows the Value field) or Formula (shows the Formula field). The default is Valor.

Value​

Enter the text, number or data to enter in the cell.

Formula​

Enter the formula to insert in the cell, starting with =. Use the English function names, for example =SUM(A1:A10). This field is shown only when Value type is Formula.

Returns​

This action has no returns.

Rules and Conditions​

  • The fields shown are required.
  • The column (and row, when applicable) reference must be valid.
  • Save the file after making changes to persist the data.
  • This action is only available on Windows, because it uses the Microsoft Excel installed on the computer. On macOS and Linux, the action fails with the message "only available on Windows".