error message: unexpected record length

Question

cgo 2017-8-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/353415-error-message-unexpected-record-length

回答： 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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2017-8-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/353415-error-message-unexpected-record-length#answer_278615

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.