writecell to excel when cell elements are matrixes

I have a 1x4 cell and each element is an nxm matrix, each matrix may or may not be different dimentions. I want to save this data to a file and I think the best is to store each matrix into a sheet of an excel file. Is there an elegant way to do this? I can only thing to do it with loops.

[dpb]

Why Excel?

Why not just save the array as ..mat file and retrieve it in MATLAB?

[george hargenrader]

1) I need to send it to collaborators who are not using matlab.

2) They will plot it in other software and make it pretty for publication.

I think the looping part will be simpler than I thought. Now I'm just trying to figure out the best way to give the columns header labels. I think writematrix does not support 'append' in 2019a.

[george hargenrader]

It turned out to be simple, I just wish I could use append rather than think about what row to start on using the 'Range' command.

for i=1:N_temps
    writematrix(Header(i,:),strcat(FileP,'MeBIMH_out_data.xlsx'),'sheet',i);
    writematrix(data{i},strcat(FileP,'MeBIMH_out_data.xlsx'),'sheet',i,'Range','A2');
end

Answer 1

[Adam Danz]

"I just wish I could use append rather than think about what row to start on using the 'Range' command."

The Matlab Genie has made your wish come true.

Update to r2020a and you can append an excel file using writematrix as reported in the r2020a release notes.

Example:

writematrix(M,'M.xls','WriteMode','append')

More info: https://www.mathworks.com/help/matlab/ref/writematrix.html#namevaluepairs