how to import cell array with different sizes into excel

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.

Answer 1

[Walter Roberson]

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

[Yussif M. Awelisah]

Please can you explain further how these two options can be achieved.

I alreadt tried a conversion into matrix but I not sure I indicated each column as you suggested.

below is what I used to convert the data into matrix

 C=x; 
    maxLengthCell=max(cellfun('size',C,2));  %finding the longest vector in the cell array
    for i=1:length(C)
        for j=cellfun('size',C(i),2)+1:maxLengthCell
             C{i}(j)=0;   %zeropad the elements in each cell array with a length shorter than the maxlength
        end
    end
    A=cell2mat(C); %A is your matrix

I hope you can explain further how I can achieve the two solutions you gave.

the length of my data is 500 for all and its 231 samples each with different size.

[Yussif M. Awelisah]

@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]

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.