Excel file can't be read properly

KNIME Analytics Platform
1

Hello everyone,
There is a problem encountered when I tried to read this excel file. Does anyone have the same issue before and solve it in the end? Thanks a lot!

image
image1723×503 15 KB

Expected result is to read the file from row 18 and use row 18 as column header.

*Excel reader
For some reason excel reader can’t load the file.

image
image818×551 20.2 KB

*CSV reader
The file can be read but all columns are squeezed into one

image
image957×245 4.68 KB
BMAtest.xls (3.7 KB)

2

The file you attached is neither an XLS (Excel) file nor a CSV (Comma Separated Values) - it looks like a tab-separated-value file with a bunch of junk in the beginning.

In the CSV reader, i believe you can specify what the delimiter is for the file - so in this case, make it a tab.