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!

Answer 1

[Oleg Komarov]

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)])

[Joseph]

Thanks so much, works perfectly!