Adding plot titles based on excel file name in a for loop
显示 更早的评论
Hi, I have a bunch of excel files that I have looped through matlab. I am able to read the files into matlab and create the graphs I want, but I would like the titles of the graphs to be the same as the excel file they came from. I am unclear how to have the title of each individual plot reflect the file name. This is my script so far:
files = dir('../../Data/USGS/USGS_StrSites/Excel_files/*.xls');
files = [files;dir('../../Data/USGS/USGS_StrSites/Excel_files/*.xls')];
for i =1:length(files(:,1))
filepath=strcat('../../Data/USGS/USGS_StrSites/Excel_files/',files(i,1).name);
%filepath=strcat('../Data/',files(i,1).name);
R = readtable(filepath);
[m,n]=size(R);
Rcell=table2cell(R);
Wcell=(Rcell(:,2:n));
WM= cell2mat(Wcell)
%Plot of discharge and temp over time
figure(i);
[ax,h1,h2] = plotyy(D,WM(:,2),D,WM(:,3),'plot');
title()
end
end
Thank you!
回答（1 个）
Star Strider
2017-7-13
Use the fileparts function to get the file name:
...
[~,filename] = fileparts(filepath);
figure(i);
[ax,h1,h2] = plotyy(D,WM(:,2),D,WM(:,3),'plot');
title(filename)
NOTE — I cannot run your code to test this, but it should work.
2 个评论
MegE
2017-7-13
Star Strider
2017-7-15
The ‘filename’ variable should be the name of the file you specified in your ‘filepath’ variable. My code worked for me when I tested it.
Check to see what your ‘filepath’ file names are.
Also, you may not be runnning my code correctly.
This is correct:
title(filename)
This is not correct:
title('filename')
类别
在 帮助中心 和 File Exchange 中查找有关 2-D and 3-D Plots 的更多信息
2017-7-15
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
