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

2015 6 22
1 个回答
更新时间：2015 6 22
3 次查看（30 天）

0 个投票

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

0 个投票

use the xlsfinfo function to read the names of all the sheets in an excel file.

1 个评论
显示 -1更早的评论 隐藏 -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

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by