Graphs for differents sheets in excel

Question

Ana Soph 2020-6-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/540071-graphs-for-differents-sheets-in-excel

关闭： MATLAB Answer Bot 2021-8-20

RamyPabHumedad.xlsx

Hi! everybody, i am using the matlab R2019a, and i have a problem, i need to obtain graphs from differents sheets, but also i do an operation (remainder two vectors)

this is my program right now, but the part of the variables is not correct, i need to use this variable for every sheet, so "Ramiro" is diferrent in every sheet and i can obtain a different graph.

I also attach the excel

Thank you so much for your valious time

xlfile = 'RamYPabHumedad.xlsx';
[~, sheets] = xlsfinfo(xlfile); 
Datenum = xlsread('RamYPabHumedad.xlsx','ErrJul2018');
Ramiro           = Datenum(:,1);
Pablo            = Datenum(:,2);
Error1           = Ramiro-Pablo
for sh = sheets %iterate over the sheets 
    shname = sh{1};
    value  = xlsread(xlfile, shname);
    figure ;
    plot(Ramiro, Error1,'.r');
    xlabel('Ramiro');
    ylabel('Error');
    title(sprintf(' %s', shname));
end