Writing excel files with different names

2 次查看（过去 30 天）
Jonathan Williams
Jonathan Williams 2021-1-13
评论： Stephen23 2021-1-13
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?

请先登录，再回答此问题。

回答（1 个）

David K.
David K. 2021-1-13
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by