Info

La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.

Graphs for differents sheets in excel

1 visualización (últimos 30 días)
Ana Soph
Ana Soph el 1 de Jun. de 2020
Cerrada: MATLAB Answer Bot el 20 de Ag. de 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

Respuestas (1)

darova
darova el 14 de Jun. de 2020
Try this

Community Treasure Hunt

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

Start Hunting!

Translated by