Error Read Excel Format

[mlauber71]

You can try to use R packages like ‘gdata’ or ‘readxl’ that can read old Excel formats:

XLS Reader old .xls file type

You could use R’s ‘gdata’ package to load the excel file. Yes not the most elegant way but it would work … [image] kn_example_excel_old_files_import.knwf (49.9 KB)

How to force column data type in "Excel Reader (XLS)" node?

that is actually a good idea I built a workflow that uses your idea and does three imports of an Excel file, one all numeric, one all strings and one guess. For the numeric ones when it might actually be a String there will be a huge number of missings. I do a calculation of % missing and I set a variable (75%) if there are 75% or more missing and the guess suggests a String it is a string. Obviously if you have date variables you would have to do something different. Here the …