Excel Reader: Issue with data types of input columns

[mlauber71]

@wurz

Excel Reader node to extract everything in string format and do the parsing on my own as a workaround.

I once built this to force all columns from an excel file to be imported as strings … using R:

reading excel files with R readxl as all numeric, all text, and guess. –...

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 …