User Tools

Site Tools


transformations:excelcommand

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
transformations:excelcommand [2026/09/18 10:34] – [Action settings] fix typo robertotransformations:excelcommand [2026/09/24 10:22] (current) – [List sheets/ranges settings] typo roberto
Line 41: Line 41:
 |Sheets only|This option creates a dataset listing the names of the sheets within the workbook in a column named //Sheet name//.\\  A second column named //Hidden// displays TRUE if the sheet is a hidden sheet, or FALSE if not.| |Sheets only|This option creates a dataset listing the names of the sheets within the workbook in a column named //Sheet name//.\\  A second column named //Hidden// displays TRUE if the sheet is a hidden sheet, or FALSE if not.|
 |Named ranges only|This option creates a dataset listing the names of the named ranges within the workbook in a column named\\ //Range name//.  A second column named //Hidden// displays TRUE if the range is hidden, or FALSE if not.| |Named ranges only|This option creates a dataset listing the names of the named ranges within the workbook in a column named\\ //Range name//.  A second column named //Hidden// displays TRUE if the range is hidden, or FALSE if not.|
-|Sheet and named ranges|This option creates a dataset listing the names of the sheets and named ranges within the workbook in a column\\ named //Sheet or range name//.  A second column named //Hidden// displays TRUE if the sheet/range is hidden, or FALSE if not.|+|Sheets and named ranges|This option creates a dataset listing the names of the sheets and named ranges within the workbook in a column\\ named //Sheet or range name//.  A second column named //Hidden// displays TRUE if the sheet/range is hidden, or FALSE if not.|
 |Add column with sheet position|For the //Sheets only// and //Sheets and named ranges// modes, check this option //on// to append a column containing the position number of the listed sheets.| |Add column with sheet position|For the //Sheets only// and //Sheets and named ranges// modes, check this option //on// to append a column containing the position number of the listed sheets.|
  
transformations/excelcommand.txt · Last modified: by roberto

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki