5.2.33. Read the Old Excel File format

<< Click to Display Table of Contents >>

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

5.2.33. Read the Old Excel File format


Icon: clip1619


Function: readExcelOld


Property window:






Short description:


Read the older .xls  Excel file format


Long Description:


The clip1621 readExcelOld action reads only the older excel file formats: i.e. the files with the extentions .xls and .xlt (from the version old version of Excel before 2003). If you need to import into Anatella some data stored into the new excel file format (i.e. the files with the extensions .xlsx or .xlsm), you should use the clip1622 readExcel action (see section 5.2.9. for more details about this action).


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



You can drag&drop a .xls file from a MS-File-Explorer-Window into an Anatella-Graph-Window: This will directly create the corresponding clip1621 ReadExcelOld Action inside the Anatella graph.


Anatella automatically recognize the “dates&times” that are stored in MS-Excel .xls files and directly import them in a human-readable-format (“yyyy-MM-dd hh:mm:ss”). If, for a reason or another, this recognition mechanism fails and you receive inside Anatella some dates stored as numbers, you can still convert these dates to “normal” Anatella dates using the “to String from Elapsed Time” option of the ChangeDataType clip1625  Action. Use these parameters:


Reference Time: 18991230 00:00:00

Elapsed Time Unit: day.


Here is a screenshot: