How to write to an excel sheet in specified columns only.
조회 수: 12 (최근 30일)
이전 댓글 표시
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
댓글 수: 0
채택된 답변
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 Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!