problem with Read excel file
1 次查看(过去 30 天)
显示 更早的评论
I have an excel file like below.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1162743/image.jpeg)
when I read it using
fid = xlsread('P645.cwu.igs14.csv');
the first column(Date) didnt read and it just give
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1162748/image.jpeg)
what is the problem?
0 个评论
回答(2 个)
Marcel Kreuzberg
2022-10-20
xlsread read numeric values by default check out readtable
regards
Marcel
2 个评论
Marcel Kreuzberg
2022-10-21
after reading the file with readtable (and the 'NumHeaderLines',11 option) you should get an table. the problem is now, that the tirst column 'Date' is not numeric. to get an matrix you have to convert the Date to numeric value first.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!