Write cell array into an excel file with multiple sheets

Question

alexandra ligeti 2023-9-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2017996-write-cell-array-into-an-excel-file-with-multiple-sheets

编辑： Florian Bidaud 2023-9-7

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Florian Bidaud 2023-9-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2017996-write-cell-array-into-an-excel-file-with-multiple-sheets#answer_1304241

编辑：Florian Bidaud 2023-9-7

在 MATLAB Online 中打开

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 个评论
显示无隐藏无

alexandra ligeti 2023-9-7

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 2023-9-7