Write/Read CSV file

8 次查看（过去 30 天）
Peng Zhao
Peng Zhao 2019-7-2
评论： Peng Zhao 2019-7-3
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 个评论
Geoff Hayes
Geoff Hayes 2019-7-2
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
Peng Zhao 2019-7-3
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.

请先登录，再进行评论。

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

回答（2 个）

Chirag Nighut
Chirag Nighut 2019-7-2
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 个评论
Peng Zhao
Peng Zhao 2019-7-3
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.

请先登录，再进行评论。

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

请先登录，再进行评论。

类别

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

标签

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by