Write different sized cell arrays of strings to one excel sheet

Question

Marcus Glover 2020-9-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/591928-write-different-sized-cell-arrays-of-strings-to-one-excel-sheet

评论： Ameer Hamza 2020-9-11

I would like to list the string values contained in cell arrays of different sizes in their own column in excel. Here's my example and goal:

 c1={'The' 'quick' 'brown'} %this should be the first column in excel
 c2={'fox' 'jumps'} %this should be the second column in excel

Goal (these are rows and columns in excel):

The fox

quick jumps

brown

My idea was to run a big loop and write each cell array as a column piecemeal using the range option in xlswrite, but was hoping there was a faster way to make one large padded array in MATLAB or something first, as I have a lot of data to write.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Ameer Hamza 2020-9-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/591928-write-different-sized-cell-arrays-of-strings-to-one-excel-sheet#answer_492859

在 MATLAB Online 中打开

Try this

c{1} = {'The' 'quick' 'brown'}; %this should be the first column in excel
c{2} = {'fox' 'jumps'}; %this should be the second column in excel
c{3} = {'over' 'the', 'lazy'};
c{4} = {'dog'};
max_size = max(cellfun(@numel, c));
c_padded = cellfun(@(x) [x.'; cell(max_size-numel(x), 1)], c, 'uni', 0);
c_padded = [c_padded{:}];
writecell(c_padded, 'filename.xlsx')