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

Get all cells in an Excel tab

Get all cells in an Excel tab

Gets the values of every filled cell in an Excel tab, returning the data as a list of rows and columns.


Options​

Excel tab​

Select the Excel tab, obtained earlier in the flow by the Select an Excel tab or Create an Excel tab actions.

Returns​

Javascript code​

js
actions["action-id"].values       // table cell values (List)
actions["action-id"].rowCount     // number of lines (Number)
actions["action-id"].columnCount  // number of columns (Number)

Field selection​

  • values — table cell values (List)
  • rowCount — number of lines (Number)
  • columnCount — number of columns (Number)

Each item of values is a row of the tab, with the list of cells of that row. Each cell is an object with value, formula, comment and position, or null when the cell is empty.

Rules and Conditions​

  • Every field is required.
  • 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".