How to read several times similarly from EXCEL?

1 次查看（过去 30 天）

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')

sheet= 'Ai'

sheet= 'A% i'

How can we do so?

Thanks

Steven

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

Steven 2013-12-29

Thanks!

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

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

Translated by