error message: unexpected record length

9 次查看（过去 30 天）
cgo
cgo 2017-8-20
回答： cgo 2017-8-21
I have an excel file 65000 x 4 which is already saved as .xls (as opposed to .xlsx). I cannot read the file because of the above error message. It tells me to save it as Excel 98, but it already is! I don't know what to do with this. How to solve this problem?

请先登录，再回答此问题。

回答（2 个）

Jan
Jan 2017-8-20
The row limit of 65535 is not the problem. Some Mac users explained in the past, that their xlsread failed, when the cells contain special characters like ° . Try to remove these characters. Saving the file as XLSX might help also.
Please mention your OS and Matlab version.
See https://de.mathworks.com/matlabcentral/newsreader/view_thread/239302.
cgo
cgo 2017-8-21
I am using a mac, with matlab 2013b.
I havent completely scanned the file, but I don't know where I could have placed a special character there.

类别

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by