export to one Excel-Sheet with different Columns
5 views (last 30 days)
Show older comments
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 Comments
Answers (2)
Titus Edelhofer
on 17 Dec 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
0 Comments
Trier87
on 17 Dec 2012
1 Comment
Titus Edelhofer
on 17 Dec 2012
This falls into the category to not seeing the woods for the trees? ;-). I guess the question may be marked as answered then ...
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!