easiest way to get structure to excel
2 次查看(过去 30 天)
显示 更早的评论
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,
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/161131/image.png)
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
2016-7-18
编辑:Naveen Baskaran
2016-7-18
Did you finally get the answer? It would be really useful if you share
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
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!