export to one Excel-Sheet with different Columns

5 views (last 30 days)
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');

Answers (2)

Titus Edelhofer
Titus Edelhofer on 17 Dec 2012
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 on 17 Dec 2012
haha im so stupid ;) Thank You
its time to leave :-D
  1 Comment
Titus Edelhofer
Titus Edelhofer on 17 Dec 2012
This falls into the category to not seeing the woods for the trees? ;-). I guess the question may be marked as answered then ...

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!