MATLAB Answers

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

8 views (last 30 days)
Coral Reyes
Coral Reyes on 22 Jun 2015
Commented: Coral Reyes on 22 Jun 2015
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?

  0 Comments

Sign in to comment.

Answers (1)

Jeremy
Jeremy on 22 Jun 2015
use the xlsfinfo function to read the names of all the sheets in an excel file.

  1 Comment

Coral Reyes
Coral Reyes on 22 Jun 2015
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

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!