5.2.32. Read Sheets Metadata from Excel files

<< 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: clip1616

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: