Info

This question is closed. Reopen it to edit or answer.

How to write this cell to a csvfile?

1 view (last 30 days)
DEVANAND
DEVANAND on 4 Apr 2014
Closed: MATLAB Answer Bot on 20 Aug 2021
Hi all, If I have a cell with contents like
{'X','Y';
1,'a';
2,'c';
3,'c'}
Now I want to convert this cell to a csvfile like below:
X,Y
1,a
2,c
3,c
How to do this using csvwrite.

Answers (1)

DEVANAND
DEVANAND on 4 Apr 2014
OK I did it. This is how I did:
fid = fopen('junk.csv','w');
fprintf(fid,'%s,%s\n',xx{1,:}); % cell name xx with 4*2 elements
for i = 2:4
fprintf(fid,'%d,%s\n',xx{i,:});
end
fclose(fid);
  2 Comments
Jan
Jan on 4 Apr 2014
Alternative without a loop:
xxt = xx(2:4, :)';
fprintf(fid,'%d,%s\n',xxt{:});
DEVANAND
DEVANAND on 4 Apr 2014
This is a better solution. Thank you.

Tags

Products

Community Treasure Hunt

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

Start Hunting!