Add data to .csv file using matlab

96 次查看（过去 30 天）
Harshita K
Harshita K 2020-10-5
评论： Sudhakar Shinde 2020-10-6
I want the data in the .csv file to look like this:
DateTime1 Username1 Path1 Remark1
Here, all the cells are strings and they are in a single row but 4 columns. Everytime I need to add data at the end of this .csv i.e. it should look something like this
How to I prepare this data? I really don't know how to prepare this data and add it to the csv in this manner. Can someone please help me out here?
I tried preparing the data in this way,
data = ['DateTime1' 'UserName1' 'Path1' 'Remark1'] But they got concatenated.

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

采纳的回答

Sudhakar Shinde
Sudhakar Shinde 2020-10-5
编辑：Sudhakar Shinde 2020-10-5
data = {'DateTime1' 'UserName1' 'Path1' 'Remark1'};
data1= {'DateTime2' 'UserName2' 'Path2' 'Remark2'};
Data = [data;data1];
writecell( Data, 'test.csv');
  3 个评论
显示 1更早的评论
Harshita K
Harshita K 2020-10-6
I could make this work by reading the csv data using
data = readcell('test.csv');
data1= {'DateTime2' 'UserName2' 'Path2' 'Remark2'};
Data = [data;data1];
writecell( Data, 'test.csv');
Thank you.

请先登录，再进行评论。

更多回答（2 个）

Jon
Jon 2020-10-5
编辑：Jon 2020-10-5
In MATLAB put the data into a table array. Then use writetable with the 'WriteMode','Append' property value pair. Please see https://www.mathworks.com/help/matlab/ref/writetable.html especially the section on adding data to end of table
  2 个评论
Harshita K
Harshita K 2020-10-5
WriteMode isn't supported in 2019b I guess, everytime I use that, there's an error that says,
Invalid parameter name: WriteMode.
Jon
Jon 2020-10-5
I didn't realize that was such a new feature. If you have it available I would recommend updating to the new version, if not just for this feature just to stay current.

请先登录，再进行评论。

Luciano Garim
Luciano Garim 2020-10-5
Hi Harshita K !
To import your data from a CSV file into MATLAB use the “readtable” function. The “readtable” function automatically detects the header and the number of lines to skip.
T = readtable('myfile.csv');
To add your data use dlmwrite
M = randn(4,4);
dlmwrite(T,M,'delimiter',',','-append');
  1 个评论
Harshita K
Harshita K 2020-10-5
This works only with numbers, when I want to add strings this is how it gets populated in the csv,

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by