How can I import an excel workbook's SHEET TITLE?

1 次查看(过去 30 天)
I am writing a program by importing data from an excel workbook and the final result is a figure for each sheet. I am using a for loop to generate all the figures and will like to use each sheet's name as the figure's title and file name. Is there a way I can connect both?

回答(1 个)

Jeremy
Jeremy 2015-6-22
use the xlsfinfo function to read the names of all the sheets in an excel file.
  1 个评论
Coral Reyes
Coral Reyes 2015-6-22
So let's say I have 4 sheets and I have my figures i write
for kk=1:1:4
x=xlsread('Excel Title.xlsx', kk, 'A2:A11'); Y=xlsread('Excel Title.xlsx', kk, 'B2:B11');
hold on;
for ii=1:1:10
plot (x(ii),y(ii))
end
title('xlsinfo')?
end
how do I use that function? I am new to Matlab

请先登录,再进行评论。

Community Treasure Hunt

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

Start Hunting!

Translated by