export to one Excel-Sheet with different Columns

17 vues (au cours des 30 derniers jours)
Trier87
Trier87 le 17 Déc 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');

Réponses (2)

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

Connectez-vous pour commenter.

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by