Save structure in Excel

Dear all,

I have a structure, which I want to save in Excel, in a way that each table is saved in different Excel sheet. Could you please help me with programming it?

dataset = 

  struct with fields:

           Credit_broad: [205×48 table]
          Credit_narrow: [205×48 table]
                TotC_HH: [205×48 table]
               TotC_NFC: [205×48 table]
                    GDP: [205×48 table]
                    ...

Answer 1

[Stephen23]

F = fieldnames(dataset);
N = 'myfile.xlsx';
for k = 1:numel(F)
    T = dataset.(F{k});
    writetable(T, N, 'Sheet',F{k})
end

https://www.mathworks.com/help/matlab/matlab_prog/generate-field-names-from-variables.html

[Joanna Przeworska]

It works as I expected. Thank you very much.

Kind regards,

JP