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

List spreadsheet sheets

List spreadsheet sheets

Returns a list with the names of every sheet in a spreadsheet opened in the flow.


Options​

Spreadsheet name​

Select the spreadsheet opened in the flow.

Returns​

Javascript code​

js
actions["action-id"].sheets // list with the names of every sheet (List)
actions["action-id"].count  // total number of sheets (Number)

Field selection​

  • sheets — list with the names of every sheet (List)
  • count — total number of sheets (Number)

Rules and Conditions​

  • The Spreadsheet name field is required.