How to create and name several excel files in a loop?

1 次查看（过去 30 天）

Jamal 2015-9-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244838-how-to-create-and-name-several-excel-files-in-a-loop

评论： Jamal 2015-9-25

Hi,

I need to save outputs of my code into excel files. As I need to do it for about 120 cases and may need to repeat it later, I was wondering how I can do this in a loop over the 120 cases saving the result for each case in a seperate excel file. I know that xlswrite creates file, but don't know how to automate it.

Any help is appreciated Jamal

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Thorsten 2015-9-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244838-how-to-create-and-name-several-excel-files-in-a-loop#answer_193565

在 MATLAB Online 中打开

Just create a new filename in each loop and write to this file:

filename = sprintf('data%03d.xls', i);

4 个评论
显示 2更早的评论隐藏 2更早的评论

Jamal 2015-9-25

编辑：Jamal 2015-9-25

Dear Thorsten, Thank you very much for your help; both worked. I also need to save the 120 experiment in one file in different sheets; any idea how to name sheets based on the experiments name which are integer numbers but not ordinal. the name are those given to the files created as above. Hope this is my last question :)

Yours, Jamal

Jamal 2015-9-25