Icon: 
Function: readExcelOld
Property window:
Short description:
Read the older .xls Excel file format
Long Description:
The 
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 
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 |
Anatella automatically recognize the “dates×” 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 
Action. Use these parameters:
•Reference Time: 18991230 00:00:00
•Elapsed Time Unit: day.
Here is a screenshot:
