How to read several times similarly from EXCEL?

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

Answer 1

[Azzi Abdelmalek]

for k=1:100
 sheet= sprintf('A%d',k)
 E{k}= xlsread('filename', sheet)
end

[Steven]

Thanks!