export to one Excel-Sheet with different Columns

5 visualizzazioni (ultimi 30 giorni)
Trier87
Trier87 il 17 Dic 2012
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');

Risposte (2)

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

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by