Reading a 97-2003 xls file
27 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Ayushman Tripathi
le 12 Août 2020
Modifié(e) : Ayushman Tripathi
le 12 Août 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
le 12 Août 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.
Réponses (2)
Rik
le 15 Juil 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 commentaire
dpb
le 15 Juil 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
le 9 Déc 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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!