Write cell array into an excel file with multiple sheets
31 次查看(过去 30 天)
显示 更早的评论
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.
0 个评论
采纳的回答
Florian Bidaud
2023-9-7
编辑:Florian Bidaud
2023-9-7
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 个评论
Florian Bidaud
2023-9-7
编辑:Florian Bidaud
2023-9-7
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.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!