MATLAB Answers

How can i convert excel file to .mat format and call to matlab code

16 views (last 30 days)
NN
NN on 21 Aug 2020
Commented: Star Strider on 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.

Accepted Answer

Star Strider
Star Strider on 21 Aug 2020
Provide the complete file path to ‘DAH.xlsx’ . That is easiest to do with the fullfile function.

  6 Comments

Show 3 older comments
NN
NN on 22 Aug 2020
i got it cleared.i have an excel file which has two columns, first column represent time of the dayfrom0.00 and second column represent values with respect to the time of the day.but when i plot the column y axis shows differently, it shows second column values but not exact time as mentioned in the first column .Waht should i do to correct the timing
Star Strider
Star Strider on 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.)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!