I have a few Excel tables with headers, but a lot of missing values in some rows.
If the data table inside the Excel file is not “formatted as table”, the sometimes Knime does not know which fields belong to the right headers/columns, and it shifts them from right to left.
So sometimes I have strings inside of columns where the original excel table has only numbers in it.
When you pre-format the excel data “as table”, then the excel reader node reads it correctly.
But I think it should work correctly anyhow (Excel also knows how to correctly align it’s columns)