How to read several times similarly from EXCEL?

1 次查看（过去 30 天）
Steven
Steven 2013-12-29
评论： Steven 2013-12-29
How can we read data from Excel for similar sheet names and even file names, I mean in a loop?
for example, we want to read data from sheets A1,A2,...A100 from an Excel file.
Can we do it in a loop? I couldn't!
Things like this do not work:
for i =1:100
sheet= 'A(i)'
E1 = xlsread('filename', sheet,'range')
or
sheet= 'Ai'
sheet= 'A% i'
How can we do so?
Thanks
Steven

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-12-29
编辑：Azzi Abdelmalek 2013-12-29
for k=1:100
sheet= sprintf('A%d',k)
E{k}= xlsread('filename', sheet)
end

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by