I just noticed Matlab's new AI Chat Playground. I should have checked this out prior to posting my question (then again, 'My MATLAB Answers' is so effective).
How to export a cell matrix into a MS Excel file
12 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Paul Barrette
el 8 de Dic. de 2023
Comentada: Voss
el 8 de Dic. de 2023
Attached is a cell array which I would like to export into a MS Excel spreasheet where each row correspond to one (of 12) years and would represent a tab inside that Excel file. Each of the 8 columns (or variables) would represent a column inside each tab.
I know this can be done with the 'xlswrite' command (see here for an example). But that command has now been superseded by the 'writecell' command, which I have problems with. Thanks!
3 comentarios
Dyuman Joshi
el 8 de Dic. de 2023
Editada: Dyuman Joshi
el 8 de Dic. de 2023
And which array from the following list are you trying to save? ans?
z = load("THRESH_DATA.mat")
Respuesta aceptada
Voss
el 8 de Dic. de 2023
filename = 'test_THRESH_DATA.xlsx';
N = size(THRESH_DATA,1);
for ii = 1:N
T = table(THRESH_DATA{ii,:});
writetable(T,filename,'Sheet',ii,'WriteVariableNames',false);
end
3 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!