How to write multiple .csv files from cell array in matlab

Question

I have a cell array. I want to write each element of the cell into a .csv file and also specifically name the file along the way.

This is my attempt:

for i=1:length(somecell)
     doublecell{i}=double(somecell{i});   
end

for j=1:length(doublecell)
    z=doublecell{j};
    csvwrite('matrix_%i.csv',z,j)
end

I hope what I'm attempting to do is clear even though it's wrong.

garserdt216 · Accepted Answer · 2016-07-25 17:14:36Z

2

You can shorten (and correct) your code as:

for i = 1:length(somecell)
    doubleVal = double(somecell{i});
    csvwrite(sprintf('matrix_%i.csv', i), doubleVal);
end

You don't have to store the double values in an intermediate cell array, as you can produce the elements while you write the CSV files.

There were actually two problems with your code:

The line z=doublecell(j) produces a cell as indexing a cell-array with parenthesis produces a cell. You would need the numeric value instead, so here the curly bracket indexing would be correct: z = doublecell{j}.
The line csvwrite('matrix_%i.csv',z,j) is incorrect. You would need sprintf to create the filename (see example).

edited Jul 25, 2016 at 17:14

garserdt216

1636 bronze badges

answered Jul 25, 2016 at 8:15

DVarga

21.9k6 gold badges57 silver badges60 bronze badges

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

1 Comment

garserdt216 Over a year ago

The first bullet was a typo on my end which I corrected in the question. Thanks for the help.

Collectives™ on Stack Overflow

How to write multiple .csv files from cell array in matlab

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related