I have a workflow that will combine multiple excel files into one file and that works as designed. [combine multiple excel files] When I changed the workflow using the excel reader by Unchecking Read the entire the data sheet then adding Reading columns A to J and Rows 1 through 5 to create a sample workflow. When I execute I get an error Execute Table: Table created from the GoffstownOneStop.xls has different structure than the previous read files. All 5 files have the exact same Column Headings so I don’t know what the issue is plus it worked when I was combing the whole xls file into one large xls file.

Hi there @sgilmour , you have columns in one of your excel file which doesn’t have data within first 11 rows. Default Excel Reader node configuration is to skip such columns (perceived as empty although they have header name) and from there error comes. To solve it simply uncheck option Skip empty columns. Br, Ivan

Combine multiple excel files but only the first 5 rows.

KNIME Analytics Platform

mlauber71 April 22, 2020, 6:50am 8

You could check this thread about reading Excel files with different structures

1 Like