Reading a 97-2003 xls file
25 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
How can I read a 97-2003 xls file into matlab. It gives me the error "not in Microsoft Excel Format"
If I resave the file as a newer verson I can read that but I have thousands of files I need to read and I can't go through manually changing each one.
Thank you.
7 Kommentare
Ayushman Tripathi
am 12 Aug. 2020
Bearbeitet: Ayushman Tripathi
am 12 Aug. 2020
I was facing the same issue("not in Microsoft Excel Format") as you were while reading .xls file (1997-2003 Excel)
I came across the following link which helped resolve the issue .
Rik
am 12 Aug. 2020
Judging by the description there I wouldn't say it is actually an Excel file, so the error is correct. A tab delimited file is not an xls.
Antworten (2)
Rik
am 15 Jul. 2019
Sometimes it helps to provide the full file name including the extension. That way Matlab doesn't have to determine the file type on its own.
1 Kommentar
dpb
am 15 Jul. 2019
+1 I missed that detail and would definitely never pass an unqualified name w/o extension to xlsread. In fact, I'd expect it to fail with "file not found" and think opening a file that could possibly be different than the one passed by name verging on the edge of being a bug.
Sohel Rana
am 9 Dez. 2021
You could use file extension.
Use xlsread ('filename.xls') instead of xlsread ('filename.xlsx') for 97-2003 xls file.
It worked for me.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!