XLS Reader issues

[fanrf]

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.

[quaeler]

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?

[mlauber71]

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

XLS Reader old .xls file type

You could use R’s ‘gdata’ package to load the excel file. Yes not the most elegant way but it would work … [image] kn_example_excel_old_files_import.knwf (49.9 KB)