Transpose xlswrite data pasting in excel

4 次查看（过去 30 天）
Afz
Afz 2013-4-16
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')

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

回答（2 个）

Image Analyst
Image Analyst 2013-4-16
coef' (trailing apostrophe) is the transpose of coef. Send that in to xlswrite.
  1 个评论
Image Analyst
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

请先登录，再进行评论。

Afz
Afz 2013-4-16
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
  1 个评论
Image Analyst
Image Analyst 2013-4-16
Please place comments as "Comments" to our "Answers", not as "Answers" to your original question. See my answer for a response.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by