Name a graph with the title of the sheets of excel

조회 수: 1 (최근 30일)
Ana Soph
Ana Soph 2020년 6월 4일
댓글: Ana Soph 2020년 6월 4일
Hi, i hope everyone have an awesome day, i have a little problem,
i do this program and everything is "ok" , but i have so much graphs and would like to add more sheets, so ... do you know what can i add to have the title of the sheets on every graph?
xlfile = 'RamYPabHumedad.xlsx';
[~, sheets] = xlsfinfo(xlfile);
cmonths = 19;
for i = 1:cmonths %iterate over the sheets
Datenum = xlsread('RamYPabHumedad.xlsx',i);
Ramiro = Datenum(:,1);
Pablo = Datenum(:,2);
Error1 = Ramiro-Pablo;
shname = i;
value = xlsread(xlfile, shname);
figure;
plot(Ramiro, Error1,'.r');
xlabel('Ramiro');
ylabel('Error');
title(sprintf('%s', shname));
end
Thanks a lot...
Best

채택된 답변

Tommy
Tommy 2020년 6월 4일
Perhaps like this?
xlfile = 'RamYPabHumedad.xlsx';
[~, sheets] = xlsfinfo(xlfile);
cmonths = 19;
for i = 1:cmonths %iterate over the sheets
Datenum = xlsread('RamYPabHumedad.xlsx',i);
Ramiro = Datenum(:,1);
Pablo = Datenum(:,2);
Error1 = Ramiro-Pablo;
shname = sheets{i}; % <---------------------- change here
value = xlsread(xlfile, shname);
figure;
plot(Ramiro, Error1,'.r');
xlabel('Ramiro');
ylabel('Error');
title(sprintf('%s', shname));
end

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Functions에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by