Writing a matrix with header into a .csv file

392 次查看（过去 30 天）
Happy gree
Happy gree 2016-4-26
评论： Vishnu Sankar 2022-4-27
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 个评论
显示 1更早的评论
Happy gree
Happy gree 2016-4-26
Hi, thank you for trying to help me.
I have inserted the code you suggested now I don't know how to input this into .csv file. It shows what I want as an outcome in the workspace area.
Regard, Happy
jgg
jgg 2016-4-27
As I suggested, use the writetable command.
You can read about that command using doc writetable

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Navdha Agarwal
Navdha Agarwal 2019-6-20
- 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')

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by