Saving multiple files in 'xlsx' format
7 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Sugar Mummy
el 12 de En. de 2022
Comentada: Sugar Mummy
el 12 de En. de 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.
0 comentarios
Respuesta aceptada
Rik
el 12 de En. de 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 comentarios
Rik
el 12 de En. de 2022
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.
Más respuestas (0)
Ver también
Categorías
Más información sobre Simulink Functions en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!