transformations:spreadsheetmetadata
This is an old revision of the document!
Table of Contents
SPREADSHEET METADATA
(Category: Import | File)
Description
This action creates a list of sheet names, range names, or both, in a spreadsheet (.xls or .xlsx) file.
Action settings
| Setting | Description |
|---|---|
| File | Fully-qualified file name of the Excel file (.xls or .xlsx) (includes relative or absolute path). |
| Mode | Defines the scope of the list returned. Options: ⊕ Sheets only, ⊕ Named ranges only, ⊕ Sheets and named ranges. |
Use cases
The Spreadsheet metadata action can be convenient for extracting sheet and range names to pass down the workflow to reference specific parts of the Excel file:
- Iterate through all or specific sheets.
- Retreive data from all or specific named ranges.
- Iterate through all or specific named ranges.
See also
transformations/spreadsheetmetadata.1615093684.txt.gz · Last modified: 2021/03/07 00:08 by craigt