export to one Excel-Sheet with different Columns
2 ビュー (過去 30 日間)
古いコメントを表示
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');
0 件のコメント
回答 (2 件)
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
0 件のコメント
Trier87
2012 年 12 月 17 日
1 件のコメント
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!