MATLAB Answers

How to convert a cell vector with numbers and non-numbers into a comma-seprated (.csv) format?

2 views (last 30 days)
Adriano
Adriano on 23 Jan 2018
Commented: Adriano on 26 Jan 2018
Hi,
I have the cell array:
Matrix(1,1) = {'ABCD'}
Matrix(1,2) = {'*'}
Matrix(2,1) = {'251'}
Matrix(2,2) = {'0'}
Matrix(3,1) = {'*'}
Matrix(3,2) = {'01/12/2001'}
I need to export a csv (I guess using csvwrite function) with this format:
ABCD,*
251,0
*,01/12/2001
Someone can help me? Many thanks!

  0 Comments

Sign in to comment.

Accepted Answer

Julia Antoniou
Julia Antoniou on 26 Jan 2018
Hi Adriano,
You could accomplish this with the following commands:
T = cell2table(Matrix);
writetable(T,'filename.csv','WriteVariableNames',false);
See this documentation page for more information about the "writetable" function.

More Answers (0)