using the title of excel spreadhseets to name graphs

조회 수: 1(최근 30일)
C.G. 2021년 2월 12일
댓글: Geoff Hayes 2021년 2월 15일
I have 39 excel spreadsheets which I have inputted into matlab and created a subplot of grpahs from.
I would like to name the respective graph based on the title of the excel spreadsheet. Is this possible?
%% plot all the sensitivty plots from the excel files
files = dir('*.xlsx');
num_files = length(files);
grainsleft = cell(length(files), 1);
for a = 1:num_files
grainsleft{a} = xlsread(files(a).name);
%% time steps
time = 1:30;
%% mass efflux vs. time
g = cell2mat(grainsleft);
%plot mass efflux
%create a
ax = gobjects(size(g));
for c = 1:size(g,1)
%create subplot
ax(c) = subplot(7,7,c);
bar(time,g(c,:), 0.01, 'EdgeColor', 'r');
hold on
grid on
xlabel('Time (S)');
ylabel('Mass Efflux');


Geoff Hayes
Geoff Hayes 2021년 2월 12일
It may be possible to add a title using title if you specifiy which axes the title should be applied to. For example, your code could include the line
title(ax(c), files(c).name)
assuming that the row of g corresponds to the correct file in files.
  댓글 수: 2
Geoff Hayes
Geoff Hayes 2021년 2월 15일
I'm assuming that there is a one-to-one correspondence of rows of g with the rows of you can use c as an index in each such that the cth row of g comes from the cth file of files.

댓글을 달려면 로그인하십시오.

Community Treasure Hunt

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

Start Hunting!

Translated by