XLS Reader issues

We are on Knime 3.2.1. In one of the workflow, the XLS reader was working fine.
Until two days ago, it threw error like this:

Caused by: java.lang.IllegalArgumentException: The supplied POIFSFileSystem does not contain a BIFF8 ‘Workbook’ entry. Is it really an excel file?

What I can do to fix it?

Thanks.

Is it possible that you were previously reading an XLS which had property sets in them and were written by Office 2003, or earlier, and the new documents failing to be read are written by Office 2007 or later?

You could use the R package gdata to read old Excel files:

1 Like

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