xlswrite to write in different columns
조회 수: 46 (최근 30일)
이전 댓글 표시
Is there a way to have xlswrite paste in data into another column besides the first column? I'm trying to write a program to combine different 1 column matrix data into one excel file. I could try putting them in as different sheets in the document, but is there a way to, say, specify that array X is exported into column B of New.xls?
댓글 수: 1
답변 (1개)
Fangjun Jiang
2011년 6월 27일
Yes. See help xlswrite
XLSWRITE(FILE,ARRAY,SHEET,RANGE)
SUCCESS = XLSWRITE('c:\matlab\work\myworkbook.xls',A,'A2:C4')
Or, it is easier to combine data in MATLAB and then write it once to xls file.
댓글 수: 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!