Transpose xlswrite data pasting in excel

Question

Afz 2013-4-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/72312-transpose-xlswrite-data-pasting-in-excel

在 MATLAB Online 中打开

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2013-4-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/72312-transpose-xlswrite-data-pasting-in-excel#answer_82451

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2013-4-16

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 2013-4-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/72312-transpose-xlswrite-data-pasting-in-excel#answer_82453

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