error message: unexpected record length
9 views (last 30 days)
Show older comments
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 Comments
Answers (2)
Jan
on 20 Aug 2017
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.
0 Comments
See Also
Categories
Find more on File Operations in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!