Using variables to name excel worksheets.
显示 更早的评论
Hello,
I was wondering if it was possible to use the xlswrite function in a way that the name of the sheet I am writing to could have the name of a current variable.
So for instance if I am changing the value of delta = x, I would have the xlswrite function say something like:
xlswrite('excelfile.xls', output, 'Delta ='x)
So that the output is written in a new sheet called Delta = x, but the value of x changes obviously.
Is this possible? I tried searching through to see if this question had been answered already, but couldn't find a relevant answer...
Thanks in advance!
采纳的回答
Oleg Komarov
2011-4-7
If x is a number then you have to convert it into a string first:
x = 10;
xlswrite('excelfile.xls', 10, ['Delta =' sprintf('%d',x)])
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
