Saving multiple files in 'xlsx' format

6 views (last 30 days)
Sugar Mummy
Sugar Mummy on 12 Jan 2022
Commented: Sugar Mummy on 12 Jan 2022
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.

Accepted Answer

Rik
Rik on 12 Jan 2022
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 Comments

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by