Effacer les filtres
Effacer les filtres

export to one Excel-Sheet with different Columns

3 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.

Community Treasure Hunt

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

Start Hunting!

Translated by