Info

이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.

Graphs for differents sheets in excel

조회 수: 1 (최근 30일)
Ana Soph
Ana Soph 2020년 6월 1일
마감: MATLAB Answer Bot 2021년 8월 20일
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

답변 (1개)

darova
darova 2020년 6월 14일
Try this

Community Treasure Hunt

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

Start Hunting!

Translated by