Excel Reader Problem

Hi Knime Expert & Enthusiastic, need your help.

When I am executing Excel reader (5 lakhs lines) following error is showing:

dataspec generated by configure does not match spec after execution

Hi @ravi13,
do you run the Excel Reader in a loop? When the table properties change from one iteration to the other, this can cause this error.
Kind regards,
Alexander

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.

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.