Transpose xlswrite data pasting in excel

This coef has 3 numbers in 1 column and I want it to be transpose and pasted in excel at DC2 what should I do ?

xlswrite('Master File.xlsm', coef, 5, 'DC2')

Answer 1

[Image Analyst]

coef' (trailing apostrophe) is the transpose of coef. Send that in to xlswrite.

[Image Analyst]

You have to keep track of the next available cell. You know where you wrote it - DC2 - and you know the size of what you wrote, so you can construct the cell reference of the next open cell. For example, you could use sprintf() to construct the cell reference string. You may also find ExcelCol useful: http://www.mathworks.com/matlabcentral/fileexchange/index?utf8=%E2%9C%93&term=excelcol

Answer 2

[Afz]

Let me extend the same question

1) How do I place this data at the *next free cell * in Column DC

2) My Sheet number is 5 and its name is Data and its name is stored in a variable called SheetNameVariable, How do I use the variable SheetNameVariable in it ?

Thanks

[Image Analyst]

Please place comments as "Comments" to our "Answers", not as "Answers" to your original question. See my answer for a response.