Writing excel files with different names

I am batch processing and at the end of each participant's data I am using writematrix to generate an output.

For example:

writematrix(cutoff,'outdataFFT.xlsx','sheet','1');

As you will be aware this generates an excel file of the data cutoff in excel with the file called ouputdataFFT.xlsx.

As I run the next participant in the batch this instruction overwrites the first. Now I can add a save line but I was wondering if there was a way of altering the name of the excel file sequentially. Sort for like

for n = 1:10

writematrix(cutoff,'outdataFFT(n).xlsx')

end

Now I know this doesn't work but was interested in whether there is a way?

[Stephen23]

"...whether there is a way?"

Of course:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

Answer 1

[David K.]

This can be done nearly the way you guessed:

for n = 1:10
writematrix(cutoff,['outdataFFT',num2str(n),'.xlsx'])
end

The key you missed is the need to convert n to a string. After that, matlab is able to nicely concatenate these strings together.

Another function that some may prefer is using sprintf:

for n = 1:10
writematrix(cutoff,sprintf('outdataFFT%d.xlsx',n))
end