Vector to one cell in excel

3 views (last 30 days)
Dominik Sustr
Dominik Sustr on 31 Oct 2020
Edited: Adam Danz on 2 Nov 2020
Hello Iam new(and dumb) to matlab and I am struggling with export data to Excel. What I need is on the firts picture, that vector is in one cell (example vector [1,0,0,0,0] is in one cell of that table, ) but when I export it to excell what I got is that every number is in its cell separeted(another picture). Can you please help me with that? Thank you.
  1 Comment
dpb
dpb on 31 Oct 2020
You can only put multiple numeric values into a single Excel cell if they are text. You'll have to convert to a string or cell string to do that.

Sign in to comment.

Answers (1)

Adam Danz
Adam Danz on 31 Oct 2020
Edited: Adam Danz on 2 Nov 2020
As dpb mentioned, you'll have to convert those vectors to strings.
C = {[0 1 1 0 0 1], [0 1 1 1], [0 0 0 0], [1], [1 1 1 1 ]};
Cstr = cellfun(@num2str,C,'UniformOutput',false)
Cstr = 1x5 cell array
{'0 1 1 0 0 1'} {'0 1 1 1'} {'0 0 0 0'} {'1'} {'1 1 1 1'}
writecell(Cstr', 'zapis.xlsx')
  1 Comment
Dominik Sustr
Dominik Sustr on 2 Nov 2020
Thank you guys you were right thank you for the help!

Sign in to comment.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!