User Tools

Site Tools


transformations:spreadsheetmetadata

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.


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.
  • Retrieve data from all or specific named ranges.
  • Iterate through all or specific named ranges.


Action settings

Setting Description
File*Fully-qualified file name of the Excel file (.xls or .xlsx) (includes relative or absolute path).
ModeDefines the scope of the list returned.
Options: Sheets only, Named ranges only, Sheets and named ranges.

* Setting can be specified using a parameter.

Mode settings

SettingDescription
Sheets onlyReturns a two-column dataset listing the sheet names found within the source file, and whether the sheets are hidden or not.
Named ranges onlyReturns a two-column dataset listing the named range names found within the source file, and whether the ranges are hidden or not.
Sheets and named rangesReturns a two-column dataset listing both the sheet names and named range names found within the source file, and whether these entities are hidden or not.


Community examples


See also

transformations/spreadsheetmetadata.txt · Last modified: 2021/07/15 12:56 by craigt