how to convert table with struct to excel sheet

3 visualizaciones (últimos 30 días)
hussain abdelaziz
hussain abdelaziz el 8 de Abr. de 2021
Comentada: hussain abdelaziz el 18 de Jul. de 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

Respuesta aceptada

Mohammad Sami
Mohammad Sami el 8 de Abr. de 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 comentarios
Mohammad Sami
Mohammad Sami el 10 de Abr. de 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 el 18 de Jul. de 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 ?

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Structures en Help Center y File Exchange.

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by