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.