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 个评论
显示 5更早的评论
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 .
https://e2e.ti.com/support/data-converters/f/73/t/771471?AFE4490SPO2EVM-AFE4490SPO2EVM
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 Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by