How to read spreadsheet files iteratively?

1 次查看（过去 30 天）

Adarsh Vasa 2020-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524167-how-to-read-spreadsheet-files-iteratively

评论： Adarsh Vasa 2020-5-9

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

per isakson 2020-5-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524167-how-to-read-spreadsheet-files-iteratively#answer_431338

Replace

readtable('filename.xls');

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

to use the value of the variable not its name.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Adarsh Vasa 2020-5-9

thank you

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by