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
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.
