Write a cell array which contains strings to a csv file

Question

Vinod 2016-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275008-write-a-cell-array-which-contains-strings-to-a-csv-file

回答： Walter Roberson 2016-3-23

在 MATLAB Online 中打开

I am trying to write a single precision floating point array to a csv file.

csvwrite('abc.csv',num2hex(single(magic(4))))

After each character, comma appears.

How to write a 4x4 matrix to csv file in which all elements are a single string.

The contents of the csv file looks like this:

4,1,8,0,0,0,0,0
4,0,a,0,0,0,0,0
4,1,1,0,0,0,0,0
4,0,8,0,0,0,0,0
4,0,0,0,0,0,0,0
4,1,3,0,0,0,0,0
4,0,e,0,0,0,0,0
4,1,6,0,0,0,0,0
4,0,4,0,0,0,0,0
4,1,2,0,0,0,0,0
4,0,c,0,0,0,0,0
4,1,7,0,0,0,0,0
4,1,5,0,0,0,0,0
4,1,0,0,0,0,0,0
4,1,4,0,0,0,0,0
3,f,8,0,0,0,0,0

I don't want any commas in between the string.

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-3-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275008-write-a-cell-array-which-contains-strings-to-a-csv-file#answer_214681

在 MATLAB Online 中打开

You cannot use csvwrite() for this. You will need to either use xlswrite() or write the file yourself.

fid = fopen('abc.csv', 'wt');
fmt = [repmat('%s,', 1, 3), '%s\n'];
datacell = arrayfun(@(x) num2hex(x), single(magic(4)), 'Uniform', 0);
fprintf(fid, fmt, datacell .');     %transpose is needed
fclose(fid)