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
11 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Dyuman Joshi
am 8 Dez. 2023
Bearbeitet: Dyuman Joshi
am 8 Dez. 2023
And which array from the following list are you trying to save? ans?
z = load("THRESH_DATA.mat")
Akzeptierte Antwort
Voss
am 8 Dez. 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!