xlswrite to specific cells

I have 3 variables that I would like to write to excel. I want them written to specific cells, like variable 'a' goes to cell A1, variable 'b' goes to cell C3 and so on. I use this code:

filenametest = 'writetest';

xlswrite(filenametest, [a b c],'Sheet1',['A1' 'C3' 'B9'])

This does not work and I can't find any solutions on any help files.

Can you help?

Thanks..

[Adam]

Looks like you'd have to just do 3 separate calls to xlswrite. The xlRange parameter clearly states it must be a rectangular range so you can't just put random cells in.

[Soren Hansen]

OK, thanks. This is what I have done so far, but i hoped that I could expedite the process by doing it in "one call".

[Jan]

Note that ['A1' 'C3' 'B9'] is the same as 'A1C3B9'. Whenever you write "does not work" in the forum, care for explaining, what happens instead: Do you get an error message or does the result differ from your expectations. Usually this explanation contains the main part of the solution already.

Answer 1

[Jan]

As Adam has suggested

xlswrite(filenametest, a, 'Sheet1', 'A1')
xlswrite(filenametest, b, 'Sheet1', 'C3')
xlswrite(filenametest, c, 'Sheet1', 'B9')

Answer 2

[KL]

If you put all the variables in one cell array, then maybe

varCell = {a,b,c};
xlCell = {'A1','B3','C7'};
cellfun(@(v,c) xlswrite(filenametest,v,1,c),varCell,xlCell)

Answer 3

[deepika Sridhar]

what is c what is v

[Walter Roberson]

In KL's answer, v and c are the dummy parameter names for the anonymous function. KL appears to have used v to stand for variable, and c to stand for cell reference.