Get Excel Sheet Names (Operator Toolbox)
SynopsisThis operator takes an Excel file and returns the list of sheets which are in this file.
DescriptionA file can either be provided as a path or as a file object on the input port. The result is an ExampleSet with two attributes: Sheet Number and Sheet Name.
- fil (File)
The excel file which should be used. This is not mandatory. File objects can be generated with operators like Open File or Loop Files.
- exa (Data Table)
The ExampleSet with the sheet names and numbers.
- file_nameThe path to the Excel file. Range: configurable
Read Sheet Names
In this example we generate an excel file and extract the sheet names of this generated file again using the file input port.