Reading a 97-2003 xls file

23 ビュー (過去 30 日間)
C
C 2019 年 7 月 12 日
回答済み: Sohel Rana 2021 年 12 月 9 日
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 件のコメント
Ayushman Tripathi
Ayushman Tripathi 2020 年 8 月 12 日
編集済み: Ayushman Tripathi 2020 年 8 月 12 日
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 .
In short, you can use the dlmread OR readmatrix command on MATLAB. It worked for me.
Rik
Rik 2020 年 8 月 12 日
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.

サインインしてコメントする。

回答 (2 件)

Rik
Rik 2019 年 7 月 15 日
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 件のコメント
dpb
dpb 2019 年 7 月 15 日
+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
Sohel Rana 2021 年 12 月 9 日
You could use file extension.
Use xlsread ('filename.xls') instead of xlsread ('filename.xlsx') for 97-2003 xls file.
It worked for me.

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by