Name a graph with the title of the sheets of excel

1 Ansicht (letzte 30 Tage)
Ana Soph
Ana Soph am 4 Jun. 2020
Kommentiert: Ana Soph am 4 Jun. 2020
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

Akzeptierte Antwort

Tommy
Tommy am 4 Jun. 2020
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

Weitere Antworten (0)

Kategorien

Mehr zu Functions finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by