Excel file can't be read properly

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!

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.

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

BMAtest.xls (3.7 KB)

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.


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