Read the older .xls Excel file format
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).
You can drag&drop a .xls file from a MS-File-Explorer-Window into an Anatella-Graph-Window: This will directly create the corresponding ReadExcelOld Action inside the Anatella graph.
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: