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:

 

clip1615

 

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:

 

clip1617