Transpose xlswrite data pasting in excel

조회 수: 2(최근 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.

댓글을 달려면 로그인하십시오.

Community Treasure Hunt

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

Start Hunting!

Translated by