Write/Read CSV file

21 views (last 30 days)
Peng Zhao
Peng Zhao on 2 Jul 2019
Commented: Peng Zhao on 3 Jul 2019
I'm trying to write table into a CSV file that looks like the following:
Capture.PNG
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.
  2 Comments
Peng Zhao
Peng Zhao on 3 Jul 2019
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.

Sign in to comment.

Answers (2)

Chirag Nighut
Chirag Nighut on 2 Jul 2019
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.
  1 Comment
Peng Zhao
Peng Zhao on 3 Jul 2019
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.

Sign in to comment.


Kaustav Bhattacharya
Kaustav Bhattacharya on 2 Jul 2019
Look at the append data section of this link. https://in.mathworks.com/help/matlab/ref/dlmwrite.html
  1 Comment
Peng Zhao
Peng Zhao on 3 Jul 2019
Hello, the problem is how to write strings into csv.
Writing regular matrices was good.

Sign in to comment.

Products


Release

R2016a

Community Treasure Hunt

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

Start Hunting!