easiest way to get structure to excel

3 views (last 30 days)
James
James on 17 Apr 2014
Commented: Image Analyst on 18 Jul 2016
Hi,
I have a structure "A" that I want to export to excel for further use. "A" has the data burried a little bit in it. The best I can describe it as is when I open up "A" it looks like the following,
When I open the 1x1 struct, there is a 1x42 double matrix (for all 4 of those) titled "results".
I want to get those matricies to excel. Is there an easy way get those matricies to Excel? Even if it is a 2 step process.
Thanks.
  2 Comments
Naveen Baskaran
Naveen Baskaran on 18 Jul 2016
Edited: Naveen Baskaran on 18 Jul 2016
Did you finally get the answer? It would be really useful if you share
Image Analyst
Image Analyst on 18 Jul 2016
Well, he never Accepted one, but I still claim my answer would have worked. Naveen, you're welcome to go ahead and try it yourself.

Sign in to comment.

Answers (2)

Azzi Abdelmalek
Azzi Abdelmalek on 17 Apr 2014
From your struct variable, you can create one 42x4 array A, then use xlswrite to export your data to an Excell file
xlswrite('file.xlsx',A)
  3 Comments
Sara
Sara on 17 Apr 2014
Can you post exactly what A is?
Azzi Abdelmalek
Azzi Abdelmalek on 17 Apr 2014
A is your data, you have to post what A looks like, or give an example

Sign in to comment.


Image Analyst
Image Analyst on 17 Apr 2014
Maybe try struct2table() and then writetable().

Community Treasure Hunt

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

Start Hunting!