export to one Excel-Sheet with different Columns

조회 수: 5 (최근 30일)
Trier87
Trier87 2012년 12월 17일
Hello, My Variable Buff is a 450x3 Matix. I want now to save each Column of Buff into one Sheet but in different Columns of a .csv-File. At the moment my code looks like this. In the Future my Variable Buff will grow into a 454757x11 Matrix, so every new Column of the Variable should be saved into a new Column in .csv. Thank You Guys
Buff
spalte1=Buff(:,1);
spalte2=Buff(:,2);
spalte3=Buff(:,3);
xlswrite('test.csv', spalte1,'Sheet1','A');
xlswrite('test.csv', spalte2,'Sheet1','B');
xlswrite('test.csv', spalte3,'Sheet1','C');

답변 (2개)

Titus Edelhofer
Titus Edelhofer 2012년 12월 17일
Hi,
what I don't understand from your question: why don't you write all columns at once? I.e.
xlswrite('test.csv', Buff, 'Sheet1', 'A1');
??
Titus

Trier87
Trier87 2012년 12월 17일
haha im so stupid ;) Thank You
its time to leave :-D
  댓글 수: 1
Titus Edelhofer
Titus Edelhofer 2012년 12월 17일
This falls into the category to not seeing the woods for the trees? ;-). I guess the question may be marked as answered then ...

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

카테고리

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