Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

Graphs for differents sheets in excel

1 vue (au cours des 30 derniers jours)
Ana Soph
Ana Soph le 1 Juin 2020
Clôturé : MATLAB Answer Bot le 20 Août 2021
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

Réponses (1)

darova
darova le 14 Juin 2020
Try this

Community Treasure Hunt

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

Start Hunting!

Translated by