File name as value of a variable

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

Answer 1

[Adam Danz]

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

I recommend using absolute paths that specify where the file will be stored by using fullfile()

d = 'C:\Users\name\Documents\MATLAB'; 
for i=1:5
    filename = sprintf('testdata_%d.xlsx',i);
    writematrix(Data,fullfile(d,filename))
end

[madhan ravi]

+1, SHAWN this answer , answered your question already. Had the same thing in mind but messsed up my answer.

[Shawn]

It's working like a charm!

Thank you Adam and Madhan for your quick responses.