Skip to main content

Get Excel Sheet Names

Synopsis​

This operator takes an Excel file and returns the list of sheets which are in this file.

Description​

A 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.

Input​

fil​

The Excel file which should be used. This is not mandatory. File objects can be generated with operators like Open File or Loop Files.

Output​

exa​

The ExampleSet with the sheet names and numbers.

Parameters​

File name​

The path to the Excel file.

See Also​