Convert structure to xls file
Show older comments
I have a structure that has 13 fields each with a table that contains a 9x5 table. How can I convert these to one excel file on different sheets?
fieldnames:
muscles = {'Rt_Mid_Delt' ,'Rt_Lat_Dorsi' ,'Rt_Lumbar_ES' ...
,'Rt_Thoracic_ES','Rt_Lat_Gastro', 'Rt_Ext_Oblique' ...
,'Rt_Int_Oblique','Rt_Rect_Abdom','Rt_Glut_med' ...
,'Rt_Semiten','Rt_VMO','Rt_Rhomboid','Rt_Serratus' };
1 Comment
Geoff Hayes
on 16 Dec 2014
Alyna - how are the structure and the table related? Or do you have a structure (with 13 fields) and a 9x5 table? Or is each element in the 9x5 table a structure (with 13 fields)? Can you provide an example?
Answers (1)
Guillaume
on 16 Dec 2014
for fn = fieldnames(muscles)'
writetable(muscles.(fn{1}), 'file.xlsx', 'Sheet', fn{1});
end
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!