How to read spreadsheet files iteratively?

I am trying to access .xls files that are indexed in the following approach:

for a=1:5 
    filename = sprintf('%s_%d','Set_90',a);
    fname=readtable('filename.xls');

But obviously, 'readtable' function is calling a file named 'filename.xls' and not 'Set_90_1.xls' . How do I change the code, in order to call the latter?

Thanks.

Answer 1

[per isakson]

Replace

readtable('filename.xls');

by

readtable( [ filename, '.xls' ] );

to use the value of the variable not its name.

[Adarsh Vasa]

thank you