5.2.9. Excel File Reader

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.2. Input Actions >

5.2.9. Excel File Reader

 
Icon: ANATEL~2_img244

 

Function: readExcel
 
Property window:

 

ANATEL~2_img243

 

Short description:

Reads a Microsoft Excel .xlsx file.

 

Long Description:

See section 5.1.1 to have more information on how to specify the filename of the .xlsx file (i.e. You can use relative path, wildcards, and Javascript to specify your filename).

 

 
Each different cell inside a .xlsx file can have a different Data-Type (i.e. it can be String, Double, Date, etc.). Furthermore, there is no way to a-priori “guess” the most common type used inside a specific column inside an Excel sheet. For these reasons, all the cells inside an Excel file are imported inside Anatella as simple “Strings”. You need to “manually” use the ChangeDataType ANATEL~2_img9  Action to set a specific type for a column.
 

 

ANATEL~2_img8

You can drag&drop a .xlsx file from a MS-File-Explorer-Window into an Anatella-Graph-Window: This will directly create the corresponding ANATEL~2_img244 ReadExcel Action inside the Anatella graph.

 

 
Excel uses two different ways to store the dates inside the .xlsx files: Dates can either be stored as Strings or integer numbers. The dates that are saved inside a .xlsx file as integer numbers are imported inside Anatella as numbers. To convert these dates to “normal” Anatella dates, you can use the “to String from Elapsed Time” option of the ChangeDataType ANATEL~2_img9  Action. Use these parameters:
 

Reference Time: 18991230 00:00:00
 

Elapsed Time Unit: day.

 

 
Here is a screenshot:
 

ANATEL~2_img249