How to read spreadsheet files iteratively?

2020 5 9
1 个回答
回答已采纳
更新时间：2020 5 9
5 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

 采纳的回答

per isakson
per isakson 2020-5-9

1 个投票

Replace
readtable('filename.xls');
by
readtable( [ filename, '.xls' ] );
to use the value of the variable not its name.

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by