Get Excel Sheet Names
Get Excel Sheet Names
Section titled “Get Excel Sheet Names”Type: excel-get-sheet-names · Package: Excel Activities v1.0.0 · Output: List
Returns a list with the names of all the sheets in the file. Useful when you don’t know in advance what the sheets are called, or when you want to process all the sheets of a workbook by looping through them.
How it works
Section titled “How it works”Returns the list of sheet names in the order they appear. Accepts session or path — see the two modes.
Required parameters
Section titled “Required parameters”Ninguno — pero debes indicar session o path.
Optional parameters
Section titled “Optional parameters”| Parameter | Editor | Description |
|---|---|---|
session | expression | Excel Open session (instead of path). |
path | expression | Route to .xlsx (required if there is no session). |
Output
Section titled “Output”Returns a List of texts with the names of the sheets.
Example
Section titled “Example”Process all sheets in a workbook:
Get Excel Sheet Names path = = asset("anual.xlsx") → output: hojas
For Each items = = hojas itemVariable = hoja └─ activities: Read Excel Sheet path = = asset("anual.xlsx") sheet = = hoja → output: datos Log message = = "Hoja " + hoja + ": " + rowCount(datos) + " filas"Related activities
Section titled “Related activities”- Read Excel Sheet — read each sheet found.
- Get Used Range — dimensions of a sheet.