MATLAB Answers

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

2 views (last 30 days)
Zeynab Mousavikhamene
Zeynab Mousavikhamene on 16 Apr 2020
Commented: Mehmed Saad on 17 Apr 2020
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?

  0 Comments

Sign in to comment.

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

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by