write a structure into the excel file not writing the structure contents

Question

Zeynab Mousavikhamene 2020-4-16

关闭： MATLAB Answer Bot 2021-8-20

I use

struct2table(strucutre name,'AsArray',1)

to convert the strctrue to the table and then using writetable to write it on the excel file.

It does the job but not include the contents of the sturcture fields in the excel file.The output excel file is this:

the text in the first row are field names. The content is not included.

Any idea?

此问题已关闭。

Answer 1

Mehmed Saad 2020-4-16

x.full_100 = rand(10,1);
x.cor_thre = rand(10,1);
x.full_65 = rand(10,1);
x.rhib = rand(10,1);
T= struct2table(x);
writetable(T,'va.xlsx')

Zeynab Mousavikhamene 2020-4-16

well you did excatly what I mentioed above and it does not work. The contents of the fields are NOT included in the excel file.

Mehmed Saad 2020-4-17