how to import cell array with different sizes into excel

1 次查看（过去 30 天）
Yussif M. Awelisah
Yussif M. Awelisah 2019-10-29
评论： Walter Roberson 2019-11-1
I have 200 samples of cell array data with different sizes but same length.
eg 3x500
6x500
2x500 etc
Please how can I import these data into excel.

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

回答（1 个）

Walter Roberson
Walter Roberson 2019-10-29
A typical way to handle that would be to write each one to a different sheet.
Another way would be to put everything together in one matrix, with an additional column indicating which matrix it belongs to
1 .... 500 columns
1 .... 500 columns
1 .... 500 columns
2 .... 500 columns
[another 4 of those and then]
2 .... 500 columns
3 .... 500 columns
3 .... 500 columns
4 .... 500 columns etc
  3 个评论
显示 1更早的评论
Yussif M. Awelisah
Yussif M. Awelisah 2019-11-1
@Water Roberson
Please your suggestions earlier can save my modeling results.
Please I wil be grateful if you can help me how I can achieve your answer earlier especially the second option.
Thank you.
Walter Roberson
Walter Roberson 2019-11-1
A = [];
for K = 1 : numel(x)
t = x{K};
start = size(A,1);
stop = start + size(t,1) - 1;
A(start:stop, 1) = K;
A(start:stop, 2:1+size(t,2)) = t;
end
The above code uses zero padding. It is possible to do NaN padding, but takes a few more lines.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by