how to convert table with struct to excel sheet
3 views (last 30 days)
Show older comments
hussain abdelaziz
on 8 Apr 2021
Commented: hussain abdelaziz
on 18 Jul 2021
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 )
0 Comments
Accepted Answer
Mohammad Sami
on 8 Apr 2021
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 Comments
Mohammad Sami
on 10 Apr 2021
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
More Answers (0)
See Also
Categories
Find more on Structures in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!