Cell array to xlsx file

Question

sai prasanna sai prasanna m s 2023-4-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1945004-cell-array-to-xlsx-file

回答： Ran Yang 2023-4-11

I have an array of cell sized 1 X 476.

Each element in the cell contains 116 X 1 sized data.

I want to convert this to a 116 X 476 data and write it into an xlsx file.

Could anyone help me with this ? Thanks.

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

请先登录，再进行评论。

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

Answer 1

Ran Yang 2023-4-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1945004-cell-array-to-xlsx-file#answer_1213359

在 MATLAB Online 中打开

You can concatenate each element of your cell array using cat or convert the cell array to a regular array using cell2mat. Then save as a spreadsheet.

x = {[1;2;3], [10;11;12]} % sample data (cell size 1x2, each cell contains data 3x1)
x = 1×2 cell array
    {3×1 double}    {3×1 double}
y = cat(2, x{:})
y = 3×2
     1    10
     2    11
     3    12
y = cell2mat(x)
y = 3×2
     1    10
     2    11
     3    12
writematrix(y, 'table.xlsx');