no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+{{ transformations:ExcelMetadataAction.png}}
+===== 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:importexcel|Import from Excel file]]