how to convert table with struct to excel sheet

2021 4 8
1 个回答
回答已采纳
更新时间：2021 7 18
5 次查看（30 天）

0 个投票

i need to know how to convert this table with struct to an excel files with all the data in ... please if you can help but the code to me ( i don't need file name ) the table has many struct

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

 采纳的回答

Mohammad Sami
Mohammad Sami 2021-4-8

1 个投票

Not really sure about what your data looks like. Assuming your structs are compatible, you can concatenate them together.
s = vertcat(result.bw{:});
s = struct2table(s);
writetable(s,'myexcel.xlsx');

4 个评论
显示 2更早的评论 隐藏 2更早的评论

8*1 struck number 2 in first photo show that table when i click on it ( every cell give information about images) ..
your code work great thank you very much mohamed ♥ but if i want to add a file name to excel sheet ? can I ?
Mohammad Sami
Mohammad Sami 2021-4-10
Yes that can be done.
if true
n = cellfun(@length,result.bw);
f = repelem(result.fileName,n);
s = vertcat(result.bw{:});
s = struct2table(s);
s.fileName = f;
writetable(s,'myexcel.xlsx');
end
hussain abdelaziz
hussain abdelaziz 2021-7-18
Dr mohamed ur code was working good when i update matlab now i try to make it don't work when i wrote
n = cellfun(@length,result.bw);
it says Error using cellfun
Input #2 expected to be a cell array, was struct instead.
what is the problem ?

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2020a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by