export a cell array with same size matrices to excel

I have a 1x23 cell with matrices inside:

30x30 double	30x30 double	30x30 double	...

How to export this cell array with matrices on excel? I want each 30x30 matrix a seperate sheet so I will have 23 sheets for the cell array.

Answer 1

[fred ssemwogerere]

Hello, something like this should do nicely:

% Taking "C" to be your cell array, and your excel file as: "myfile.xlsx"
for k=1:size(C,2)
    xlswrite('myfile.xlsx',C{k},'Sheet',k);
end

[Melody Lyu]

Thanks, this looks right but I am getting an error:

"Error using xlswrite (line 170)

Range argument must be specified as a string scalar or

character vector in Excel A1 notation.

Error in directoryData (line 86)

xlswrite('myfile.xlsx',C{i},'Sheet',i);"

[fred ssemwogerere]

Hello, sorry my mistake. Change the code to this:

% Taking "C" to be your cell array, and your excel file as: "myfile.xlsx"
for k=1:size(C,2)
    xlswrite('myfile.xlsx',C{k},k); % I have removed the string "Sheet".  
end