File name as value of a variable
111 views (last 30 days)
Show older comments
Would you please guide me how to write Excel files whose names are value of a variable, e.g. testdata_i where i is a variable?
This is the code I have that needs some adjustments. Data is a matrix whose values is decided in another loop.
for i = 1:5
filename = sprintf('%s_%d','testdata',i)
writematrix(Data,'filename.xlsx')
end
0 Comments
Accepted Answer
Adam Danz
on 24 Jun 2019
Edited: Adam Danz
on 24 Jun 2019
You were really close. You just forgot to use the filename variable.
for i=1:5
filename = sprintf('testdata_%d.xlsx',i);
writematrix(Data,filename)
end
d = 'C:\Users\name\Documents\MATLAB';
for i=1:5
filename = sprintf('testdata_%d.xlsx',i);
writematrix(Data,fullfile(d,filename))
end
2 Comments
madhan ravi
on 24 Jun 2019
+1, SHAWN this answer , answered your question already. Had the same thing in mind but messsed up my answer.
More Answers (0)
See Also
Categories
Find more on Environment and Settings in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!