export to one Excel-Sheet with different Columns

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일

0 개 추천

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일

0 개 추천

haha im so stupid ;) Thank You
its time to leave :-D

댓글 수: 1

This falls into the category to not seeing the woods for the trees? ;-). I guess the question may be marked as answered then ...

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

카테고리

도움말 센터File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

질문:

2012년 12월 17일

Community Treasure Hunt

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

Start Hunting!

Translated by