Here is one example how to read different excel files with the help of R and let some logic decide what type a column is. Maybe this could help. I think the KNIME Excel Reader mostly expects the column number and types to stay constant (or it will throw a warning).
Or you would have to disable the preview in the Excel reader and see if that stops the messages, with the mentioned downsides.
