Writing a matrix with header into a .csv file
428 views (last 30 days)
Show older comments
I have this matrix:
A=(1 2 3;4 5 6)
I want to add headline to the matrix as the output is in .csv file. This is what I have tried so far.
filename= uigetfile('*.csv','choose data file');
title ={'x-axis' ,'y-axis','z-axis'};
if exist('filename');
csvwrite('result.csv',title,A);
end
The output should look like this in csv:
|x-axis|y-axis|z-axis|
|1 |2 |3 |
|4 |5 |6 |
This is supposed to be a lookalike of excel cell :) I'd be very grateful if someone could recommend a way to figure this out.
Regard, Happy
3 Comments
jgg
on 27 Apr 2016
As I suggested, use the writetable command.
You can read about that command using doc writetable
Answers (1)
Navdha Agarwal
on 20 Jun 2019
- If you do not want the titles or the name of the columns then you can use:
A=[1 2 3;4 5 6]
csvwrite('file.csv',A)
- If you want to specify the name of the titles as well then you can first convert the matrix into the table and then write the table to the csv file.
A=[1 2 3;4 5 6]
T = array2table(A)
T.Properties.VariableNames(1:3) = {'x_axis','y_axis','z_axis'}
writetable(T,'file1.csv')
1 Comment
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!