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

Get the value of a cell

Get the value of a cell

Gets the value and the formula of a specific cell in a tab of an Excel file.


Options​

Excel tab​

Select or enter the Excel tab that holds the cell.

Column to get the information​

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

Line to get the information​

Enter the number of the cell's row, for example 2.

Returns​

Javascript code​

js
actions["action-id"].value    // cell value (Any)
actions["action-id"].formula  // cell formula (Text)

Field selection​

  • value — cell value (Any)
  • formula — cell formula (Text)

Rules and Conditions​

  • Every field is required.
  • The column and row reference must be valid (e.g. Column A, Row 2).
  • 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".