Write cell array into an excel file with multiple sheets

41 views (last 30 days)
Hi all,
I have looked at previous examples but struggling to get this working. I have a cell array called gc and it is 1x10 long. I would like to store each structure within the cell array into a single excel spreadsheet with multiple sheets. For example I would like all the contents of gc{1x1} stored in a excel spreadsheet on sheet one with with the various titles, but gc{1, 2} should be on sheet two of the same excel workbook. I have attached two images to hopefully highlight what I am trying to do. I would like the resulting excel spreadsheet to be a single workbook with 10 sheets, with each sheet containing the named fields in the second image. How would I go about doing this?
Thank you so much in advance.

Accepted Answer

Florian Bidaud
Florian Bidaud on 7 Sep 2023
Edited: Florian Bidaud on 7 Sep 2023
Untested but something like this should work. This is considering you have the same field names for all the structures, and that you have less than 26 fields per structure.
fn = fieldnames(gc{1,1});
for i = 1:length(gc)
writecell(fn','excel_file.xls','Sheet',i)
for j = 1:length(fn)
[~,sizey] = size(gc{1,i}.(fn{j}));
if sizey > 1
gc{1,i}.(fn{j}) = gc{1,i}.(fn{j})';
end
writecell(gc{1,i}.(fn{j}),'excel_file.xls','Range',[char(j-1+'A') '2'],'Sheet',i)
end
end
  2 Comments
alexandra ligeti
alexandra ligeti on 7 Sep 2023
That is great, thanks so much. It works if I use writematrix instead of writecell. A quick questions, if I wanted the columns titled to the same names as the field where would one go about putting that? Would i modify the writecell (which is now wrietmatrix)?
Thanks again!!!!
Florian Bidaud
Florian Bidaud on 7 Sep 2023
Edited: Florian Bidaud on 7 Sep 2023
It should be already done in this code with writecell(fn','excel_file.xls','Sheet',i) on the third line.
For this one you can't replace it with writematrix as these are text fields.

Sign in to comment.

More Answers (0)

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!