Info

This question is closed. Reopen it to edit or answer.

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

1 view (last 30 days)
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?

Answers (1)

Mehmed Saad
Mehmed Saad on 16 Apr 2020
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')
  2 Comments
Zeynab Mousavikhamene
Zeynab Mousavikhamene on 16 Apr 2020
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
Mehmed Saad on 17 Apr 2020
  1. all the variables are column vector
  2. i didn't use 'AsArray'
  3. i get this excel file after runing code

Tags

Community Treasure Hunt

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

Start Hunting!