Add data to .csv file using matlab

Question

Harshita K 2020-10-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/605179-add-data-to-csv-file-using-matlab

评论： 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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Sudhakar Shinde 2020-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/605179-add-data-to-csv-file-using-matlab#answer_505282

编辑：Sudhakar Shinde 2020-10-5

在 MATLAB Online 中打开

data = {'DateTime1' 'UserName1' 'Path1' 'Remark1'};
data1= {'DateTime2' 'UserName2' 'Path2' 'Remark2'};
Data = [data;data1];
writecell( Data, 'test.csv');

3 个评论
显示 1更早的评论隐藏 1更早的评论

Harshita K 2020-10-6

在 MATLAB Online 中打开

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.

Sudhakar Shinde 2020-10-6

Welcome

请先登录，再进行评论。

Answer 2

Jon 2020-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/605179-add-data-to-csv-file-using-matlab#answer_505264

编辑：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 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 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.

请先登录，再进行评论。

Answer 3

Luciano Garim 2020-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/605179-add-data-to-csv-file-using-matlab#answer_505267

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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,

请先登录，再进行评论。