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

List Excel tabs

List Excel tabs

Returns a list with the names of every tab in an Excel file opened in the flow.


Options​

Excel​

Select the Excel file opened earlier in the flow.

Returns​

Javascript code​

js
actions["action-id"].worksheets  // excel tab names (List)
actions["action-id"].count       // number of tabs in Excel (Number)

Field selection​

  • worksheets — excel tab names (List)
  • count — number of tabs in Excel (Number)

Rules and Conditions​

  • The Excel 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".