I want to store two worksheets together in excel sheet from matlab.
조회 수: 2 (최근 30일)
이전 댓글 표시
please help as I am only able to store only one worksheet at a time.
댓글 수: 0
답변 (1개)
Azzi Abdelmalek
2012년 11월 21일
a=rand(5)
b=rand(5)
xlswrite('filename.xls',a,'sh1')
xlswrite('filename.xls',b,'sh2')
댓글 수: 4
Azzi Abdelmalek
2012년 11월 26일
편집: Azzi Abdelmalek
2012년 11월 26일
You din'nt mention the sizes of your variables (number of lines and column of each variable). If your variables have the same number of lines you can concatenate them for example:
var1=rand(10,2);
var3=rand(10,4);
var3=rand(10,5;
data=[var1 var2 var3]
xlswrite('filename.xls',data)
If not, tell us what kind of data are you using?
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!