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
E1 = xlsread('filename', sheet,'range')
sheet= 'A% i'
How can we do so?