MATLAB: Export cell array into Excel

cell arrayexcel

Hello All,
I have been asked to quickly put together a data extraction tool for some data being collected for a research project. The data has been exported into a 36×1 cell (data_1) which comprises of 36 14×1 double vectors.
I have been asked that this data is exported onto one excel sheet. From what I have read I need to take the cell array data_1 and turn it into one 14×36 cell array.
Below is that code that I have been working with along with a screenshoot of the current output. As you can see there are 36 cells which are not correct however the rest of the data in the cell is correct.
What am I doing wrong?
Many thanks in advance 
for ii = 1:length(Trials)
    
    data_1_extraction = data_1{ii,1}; % Extract first cell.
    ca{ii} = cell(14,length(Trials));
    for row = 1 : size(data_1_extraction, 1)
    ca{row,ii} = data_1_extraction(row);
end
end

Best Answer

C=num2cell(cell2mat(data_1.'));
xlswrite(file,C,sheet,range)
Related Question