MATLAB Answers

How to read spreadsheet files iteratively?

1 view (last 30 days)
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.

  0 Comments

Sign in to comment.

Accepted Answer

per isakson
per isakson on 9 May 2020
Replace
readtable('filename.xls');
by
readtable( [ filename, '.xls' ] );
to use the value of the variable not its name.

More Answers (0)