Writing a matrix with header into a .csv file
428 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
jgg
am 27 Apr. 2016
As I suggested, use the writetable command.
You can read about that command using doc writetable
Antworten (1)
Navdha Agarwal
am 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 Kommentar
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!