Write/Read CSV file

I'm trying to write table into a CSV file that looks like the following:

Row 1 will be kept the same, then the other rows will be added to the file while the script is running (or added at once at the end).

I tried using writetable, csvwrite, etc... but it does not come out to what I want, and I am having trouble creating a matrix with text.

Please help. Thanks.

[Geoff Hayes]

Peng - please clarify what you mean by but it does not come out to what I want. Does something get written to file? Is some data overwritten by other data? What code have you written?

[Peng Zhao]

I was not able to create a matrix with strings, for example:

I want:

x = ['one','two','three'];

but the output is:

x = 
    [o n e t w o t h r e e]

not

x = 
    [one two three]

thus when I write it into csv, the format is wrong.

Answer 1

[Chirag Nighut]

To create a matrix with text you can create a 2D array of chars. To do that you can use the following code:

data = ['MATLAB   ';'SIMULINK ';'POLYSPACE'];
celldata = cellstr(data)
chr = char(celldata)

Although before using char you should check if celldata is cell array of character vetors. Following function can help you

iscellstr

I request you to post the exact error/difficulty that you got using csvwrite and writetable. I can then try to help you get the desired results.

[Peng Zhao]

This is what I tried to do for the first row of the csv file:

delete Task_Import.csv
CSV1stLine = ['Type','Summary','Planned For','Filed Against','Parent','Owned By','Estimate'];
csvwrite('Task_Import.csv',CSV1stLine)

and the csv file that was generated had only one letter in each cell.

Also, for the summary column, I will need to write an sentense into the cell from user input.

Answer 2

[Kaustav Bhattacharya]

Look at the append data section of this link. https://in.mathworks.com/help/matlab/ref/dlmwrite.html

[Peng Zhao]

Hello, the problem is how to write strings into csv.

Writing regular matrices was good.