MATLAB: How to export cell array to excel

Question

My code generates a cell array with five (5×5) num cells and now I need to export it in a way that each cell of the array will be written in a different sheet of an excel file.

Actually if I use xlswrite, an empty xls file is generated.

I apologize for the silly question but I am a new matlab user and I have not found any useful information in the community

Thanks in advance

Davide

Answer 1

Lets say "cell_data" is cell array

[r c]=size(cell_data);
sheet_num=1;
for i=1:r
for j=1:c
data=cell_data{i,j};
xlswrite('cell_data.xlsx',data,['Sheet',num2str(sheet_num)]);
sheet_num=sheet_num+1;
end
end