easiest way to get structure to excel

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.

[Naveen Baskaran]

Did you finally get the answer? It would be really useful if you share

[Image Analyst]

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.

Answer 1

[Azzi Abdelmalek]

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)

[James]

I have tried to turn the structure into an array, but it would just make a 1x4 array with the 1x1 structures. How do I make it into the 42x4 array?

[Sara]

Can you post exactly what A is?

[Azzi Abdelmalek]

A is your data, you have to post what A looks like, or give an example

Answer 2

[Image Analyst]

Maybe try struct2table() and then writetable().