how to convert table with struct to excel sheet

1 Ansicht (letzte 30 Tage)
hussain abdelaziz
hussain abdelaziz am 8 Apr. 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 ) the table has many struct

Akzeptierte Antwort

Mohammad Sami
Mohammad Sami am 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 Kommentare
Mohammad Sami
Mohammad Sami am 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
hussain abdelaziz
hussain abdelaziz am 18 Jul. 2021
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 ?

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange

Produkte


Version

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by