XLS Reader will not read a .xls file

KNIME Analytics Platform
1

Hello,

I am receiveing an excel report via email from a hosted application. I am using the XLS reader to manipulate the file into .csv that can be processed into the Data Warehouse.

The problem is that the .xls file that is downloaded from the email cannot be read by KNIME. I have to open the file in Excel then save the file. After saving the file KNIME can read the file. The only error in the Console when trying to read the original .XLS attachement is "Please select a worksheet". Since the file is not being read, no sheet labels are able to be selected.

If I use the Read XLS Sheet Names object to read the unreadable file, the following error is sent to the Console log: Execute failed: Initialisation of record 0xE2 left 2 bytes remaining still to be read.

Any thoughts on how to resolve would be appreciated.

2

Have you checked that the file is indeed an Excel file and not a text (CSV) file with an .xls extension?

3

 I have checked the file in notepad and it is definately not a text file.

Thanks for the suggestion however.

4

Hello, 

I'm having a similar issue with the XLS Reader node. I'm getting an error that it's not an OLE2 or OOXML file, though it is definitely XML-based. The file is generated by Facebook to output Insights data, and has 26 worksheets. 

I found a thread (https://bug.javlin.eu/browse/CLO-4225) about a different Java product that mentioned it might be in SpreadsheetML format, but it doesn't look like it matches the schema. 

Here are the first few lines: 

<?xml version="1.0" encoding="UTF-8"?>
                      <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
                       xmlns:x="urn:schemas-microsoft-com:office:excel"
                       xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
                       xmlns:html="http://www.w3.org/TR/REC-html40">

Thanks!

Chris

5

Has anyone figured out why this is happening and how to fix it? I am currently having this problem.

 

Thanks!

Nadir