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)

Community Treasure Hunt

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

Start Hunting!