Info

Diese Frage ist geschlossen. Öffnen Sie sie erneut, um sie zu bearbeiten oder zu beantworten.

Graphs for differents sheets in excel

1 Ansicht (letzte 30 Tage)
Ana Soph
Ana Soph am 1 Jun. 2020
Geschlossen: MATLAB Answer Bot am 20 Aug. 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

Antworten (1)

darova
darova am 14 Jun. 2020
Try this

Community Treasure Hunt

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

Start Hunting!

Translated by