With Knime 4.3 I found a problem using the new excel reader in a loop. I have multiple table Excel table with the same structure that I need to consolidate (through a loop), but the problem with new excel reader is that for my first table the amount column is read as an Integer but the second table in the loop the amount is defined as Double which cause the loop to fail at the excel reader level as is it can’t read the Double as Integer. Even with the enforce type unchecked, the loop fail, I think that transformation tab option are too strict, it should allow to choose a type we need and not enforce the one it chooses by itself.
The only way to resolve to resolve the problem for me is to you use the deprecated version of excel reader
you need to use a different path variable when configuring the Excel reader. E.g., copy the file to another location and use that path as variable. Then configure the Excel Reader. Afterwards, change your path variable back. This will cause the Excel Reader to re-calculate the spec in every loop iteration.
If there are still issues, increase or remove the limit of rows that are scanned on the Advanced Settings tab.
