Differences

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

--- transformations:spreadsheetmetadata [2021/03/07 00:08] – craigt
+++ transformations:spreadsheetmetadata [2021/07/15 12:56] (current) – craigt
@@ Line 1: / Line 1: @@
 {{ transformations:ExcelMetadataAction.png}}
-===== SPREADSHEET METADATA =====
+====== SPREADSHEET METADATA ======
-(Category: //Import | File//)
+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:\\
+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.
+  * Retrieve data from all or specific named ranges.
   * Iterate through all or specific named ranges.
+\\
+=====Action settings=====
+^ Setting  ^ Description  ^
+|File<sup>*</sup>|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//.|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+====Mode settings====
+^Setting^Description^
+|Sheets only|Returns a two-column dataset listing the //sheet names// found within the source file, and whether the sheets are hidden or not.|
+|Named ranges only|Returns 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 ranges|Returns 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=====
+  * [[https://community.easymorph.com/t//1766/1|Load only workbooks with given number of sheets]] ([[https://community.easymorph.com/uploads/short-url/AbWPlfPVBecqgZUBVTYlljwb9NO.morph|Project]]; Module: //Get sheet names//; Group: //Tab 1//; Table: //Imported table 1//;\\ Action position: //1//)
 \\
@@ Line 24: / Line 36: @@
   * [[transformations:importexcel|Import from Excel file]]