MATLAB - write cell array to csv file

Question

I have a cell array that has both characters and numbers as values. What is the simplest way to output it in a csv file, row by row, maintaining the structure of the cell array? For example, if the cell array is

[abc] [1] [131]
[def] [] []
[gh] [13] [999]

I want the file to look like

abc,1,131
def,,
gh,13,999

similar question: stackoverflow.com/questions/6752102/…

Amro
– Amro

2011-08-10 00:08:30 +00:00
Commented Aug 10, 2011 at 0:08 — Amro
– Amro, Commented Aug 10, 2011 at 0:08

Amro · Accepted Answer · 2011-08-09 23:39:31Z

5

Example:

%# cellarray
C = {
    'abc' [1]  [131]
    'def' []   []
    'gh'  [13] [999]
};

%# write line-by-line
fid = fopen('file.csv','wt');
for i=1:size(C,1)
    fprintf(fid, '%s,%d,%d\n', C{i,:});
end
fclose(fid);

answered Aug 9, 2011 at 23:39

Amro

125k25 gold badges250 silver badges466 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Trup Over a year ago

Should this file already exist or I create it this way? I am getting ??? Error using ==> fprintf Invalid file identifier. Use fopen to generate a valid file identifier. Error in ==> parseTickData at 134 fprintf(fd, '%s,%f,%d%f%d%f%d\n', C{i,:});

Amro Over a year ago

@Trup: it should create a new file if it didn't already exist, and overwrite it if it did.. Also can you show us what a row in your actual cellarray looks like?

Collectives™ on Stack Overflow

MATLAB - write cell array to csv file

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related