Info

Questa domanda è chiusa. Riaprila per modificarla o per rispondere.

Graphs for differents sheets in excel

1 visualizzazione (ultimi 30 giorni)
Ana Soph
Ana Soph il 1 Giu 2020
Chiuso: MATLAB Answer Bot il 20 Ago 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

Risposte (1)

darova
darova il 14 Giu 2020
Try this

Community Treasure Hunt

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

Start Hunting!

Translated by