How to write cell array to excel file

Question

parham kianian 2020-4-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516736-how-to-write-cell-array-to-excel-file

回答： Qiang Lei 2022-5-20

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

I have a cell array whose elements have different sizes. How can I write it to an excel file?

For example:

a = rand(10,1);
b = rand(5,1);
c = rand(4,8);
X = {a, b, c};

How can I export X to an excel file?

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-4-9

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516736-how-to-write-cell-array-to-excel-file#answer_425097

在 MATLAB Online 中打开

If the desired output is a worksheet in which the first column has 10 rows, and the second column has 5 rows, and then the next 8 columns have 4 rows, with the unused portions of each column being empty: then you cannot directly do that.

However, you can use:

vars = {a,b,c};
varnames = {'a', 'b', 'c'};
rows = cellfun(@(M) size(M,1), vars);
cols = cellfun(@(M) size(M,2), vars);
maxrows = max(rows);
T = table();
for K = 1 : length(varnames)
    T.(varnames{K}) = [vars{K}; nan(maxrows - rows(K), cols(K))];
end
writetable(T, 'X.xlsx');