Reading a 97-2003 xls file
10 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Ayushman Tripathi
il 12 Ago 2020
Modificato: Ayushman Tripathi
il 12 Ago 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
il 12 Ago 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.
Risposte (2)
Rik
il 15 Lug 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 Commento
dpb
il 15 Lug 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
il 9 Dic 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 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!