Save structure in Excel

3 次查看（过去 30 天）
Joanna Przeworska
评论： Joanna Przeworska 2021-3-4
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]
...

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

采纳的回答

Stephen23
Stephen23 2021-3-4
编辑：Stephen23 2021-3-4
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
  1 个评论
Joanna Przeworska
Joanna Przeworska 2021-3-4
It works as I expected. Thank you very much.
Kind regards,
JP

请先登录，再进行评论。

更多回答（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!

Translated by