How can i convert excel file to .mat format and call to matlab code
34 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
NN
am 21 Aug. 2020
Kommentiert: Star Strider
am 22 Aug. 2020
I have an excel file named DAH,numeric file .How can i call that excel file to matlab code.Should i convert it to .mat format to call?
please find the below code
filename = 'DAH.xlsx';
a = xlsread(filename);
save(matfileName,'a');
x=a(:,1);
plot(x)
i am getting this error
Error using xlsread (line 136)
XLSREAD unable to open file 'DAH.xlsx'.
File 'C:\Users\Neethu Elizabeth\Downloads\DAH.xlsx' not found.
1 Kommentar
Adam Danz
am 22 Aug. 2020
The xlsread function is a bit outdated. Consider replacing it with readtable, readmatrix, or readcell.
Akzeptierte Antwort
Star Strider
am 21 Aug. 2020
6 Kommentare
Star Strider
am 22 Aug. 2020
I cannot determine that because I do not know what the first column is. I also do not know what version/release of MATLAB you have.
One option, to be safe, is to to use the datenum function to convert the times to date numbers. Those values should plot correctly.
(A better approach would be to use datetime, and perhaps readtable or readmatrix instead of xlsread, however I do not know if you have those options.)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!