Saving multiple files in 'xlsx' format

1 次查看（过去 30 天）

Sugar Mummy 2022-1-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1627465-saving-multiple-files-in-xlsx-format

评论： Sugar Mummy 2022-1-12

Hello everyone,

I have been working on a script where I have to store multiple files (say 10 files) like TestingFile1, TestingFile2 and so on...

This code is working but it only stores the last value of T. The code is shown below

for one = 1:length(p) 
    for two= 1:length(o)
        T = table(c{1,2}.time, oo{1,two}.signals.values, pp{1,one}.signals.values)
    end
end
writetable(T,'TestingFile.xlsx'); %problem in this part

Any help would be highly appreciated.

PS: The length of one and two is equal.

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

请先登录，再进行评论。

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

采纳的回答

Rik 2022-1-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1627465-saving-multiple-files-in-xlsx-format#answer_873150

Use sprintf to create a filename based on your variables.

for one = 1:numel(p)
    for two= 1:numel(o)
        T = table(c{1,2}.time, oo{1,two}.signals.values, pp{1,one}.signals.values);
        filename=sprintf('TestingFile_%d_%d.xlsx',one,two);
        writetable(T,filename);
    end
end

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

Rik 2022-1-12

Have you read the documentation for sprintf?

If you need a file counter, why don't you use and explicit one? You're close with the code you've written so far. Just set a counter before your loop and increment it inside your loop.

Sugar Mummy 2022-1-12