easiest way to get structure to excel

3 次查看（过去 30 天）
James
James 2014-4-17
评论： Image Analyst 2016-7-18
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 个评论
Naveen Baskaran
Naveen Baskaran 2016-7-18
编辑：Naveen Baskaran 2016-7-18
Did you finally get the answer? It would be really useful if you share
Image Analyst
Image Analyst 2016-7-18
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.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Azzi Abdelmalek
Azzi Abdelmalek 2014-4-17
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 个评论
显示 1更早的评论
Sara
Sara 2014-4-17
Can you post exactly what A is?
Azzi Abdelmalek
Azzi Abdelmalek 2014-4-17
A is your data, you have to post what A looks like, or give an example

请先登录，再进行评论。

Image Analyst
Image Analyst 2014-4-17
Maybe try struct2table() and then writetable().

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by