<< Click to Display Table of Contents >> Navigation: 5. Detailed description of the Actions > 5.2. Input Actions > 5.2.32. Read Sheets Metadata from Excel files |
Icon:
Function: readExcelSheets
Property window:
Short description:
Extract the Sheet names from Excel files.
Long Description:
This action can process any Excel file format (old and new: .xls and .xlsx).
See section 5.1.1 to have more information on how to specify the filename of the .xls/.xlsx file (i.e. You can use relative path, wildcards, and Javascript to specify your filename).
Typically, this action is useful when you want to read all the sheets from one (or many) excel files. For example, the Anatella graph here below outputs into a single big table the content of all the sheets from all the excel files stored in a given directory: