How to write elements of a nested cell array to an excel?

Question

maruljay 2019-7-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/473964-how-to-write-elements-of-a-nested-cell-array-to-an-excel

编辑： Andrei Bobrov 2019-7-29

采纳的回答： Andrei Bobrov

Hi all,

I have nested cell array where each cell array contains a time series.

How do I write the contents of each of the cell array into rows in excel in the same sheet?

Like for example i want WS {2,1} to be written to the 2nd row in excel in the same sheet.

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2019-7-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/473964-how-to-write-elements-of-a-nested-cell-array-to-an-excel#answer_385307

编辑：Andrei Bobrov 2019-7-29

在 MATLAB Online 中打开

for old version of MATLAB

n = cellfun(@numel,WC);
k = cumsum(n);
ii = k - n + 1;
v = ones(k(end),1);
v(ii(2:end)) = v(ii(2:end)) - n(1:end-1);
A = accumarray([repelem((1:numel(n))',n),cumsum(v)],[C{:}]',[],[],nan);
xlswrite('yourxlsxfile.xlsx',A);

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

请先登录，再进行评论。

Answer 2

dpb 2019-7-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/473964-how-to-write-elements-of-a-nested-cell-array-to-an-excel#answer_385305

在 MATLAB Online 中打开

Since all aren't same size, the trivial solution of

xlswrite(cell2mat(WS))

is out unless you augment the shorter to the length of longest.

If doing that is out, you'll have to either loop or use cellfun to write each array element.

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

请先登录，再进行评论。

Answer 3

TADA 2019-7-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/473964-how-to-write-elements-of-a-nested-cell-array-to-an-excel#answer_385306

编辑：TADA 2019-7-29

在 MATLAB Online 中打开

The problem starts with the different sizes of each rpw which makes it more complecated to unravel the nested cell arrays

c = {{1 2 3}; {1 2 3 4}; {1 2 3}};
% check row sizes
sizes = cellfun('length', c);
maxlen = max(sizes);
% equalize row sizes
for i = 1:numel(c)
    c{i} = [c{i} cell(1,maxlen-sizes(i))];
end
% unravel cell array into a 2d cell array
c1 = vertcat(c{:});
% now you can export it easily
writecell(c1, 'c.xlsx', 'sheet', 1)