How to write to an excel sheet in specified columns only.

조회 수: 12 (최근 30일)
irtiza
irtiza 2014년 5월 21일
댓글: irtiza 2014년 5월 21일
Hi I am using xlswrite(); to write my variable into excel sheet it works perfect but it writes my variable in the first row where as iw ant to write it in my first column and then i have another variable i want to write it in second column. Say for example my first variab is x-axisCordinates i do this xlswrite('testdata',x-axisCordinates) it write all the data in first row where as i wanted it in to be in the first column. Secondly after writing this i have another variable call y-axisCordinates i want to write it in the second column now. Thanks anyways Regards

채택된 답변

Yao Li
Yao Li 2014년 5월 21일
1. xlswrite('testdata',x-axisCordinates') ,"'" to convert to a nx1 array
2. You can specify the range ('C1:C5')
xlswrite(filename,A,range)

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by