how to convert table with struct to excel sheet
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
hussain abdelaziz
il 8 Apr 2021
Commentato: hussain abdelaziz
il 18 Lug 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 Commenti
Risposta accettata
Mohammad Sami
il 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 Commenti
Mohammad Sami
il 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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Structures in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!