problem with Read excel file
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (2)
Marcel Kreuzberg
el 20 de Oct. de 2022
xlsread read numeric values by default check out readtable
regards
Marcel
2 comentarios
Marcel Kreuzberg
el 21 de Oct. de 2022
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.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!