export to one Excel-Sheet with different Columns

5 次查看（过去 30 天）
Trier87
Trier87 2012-12-17
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
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
haha im so stupid ;) Thank You
its time to leave :-D
  1 个评论
Titus Edelhofer
Titus Edelhofer 2012-12-17
This falls into the category to not seeing the woods for the trees? ;-). I guess the question may be marked as answered then ...

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by