Export Structure to csv file
显示 更早的评论
Hi everyone,
I'm trying to export my data which is saved in a structure to a csv file. The structure is two dimensional but contains vectors in some cells. So far I tried to convert it in a table and save it using writetable, but the vectors were not recorded correctly.
Thanks for any advice,
Kathrin
2 个评论
Turlough Hughes
2020-9-29
Can you attach the structure to the question?
Kathrin Sadus
2020-9-29
采纳的回答
Ameer Hamza
2020-9-30
1 个投票
MATLAB just introduced writestruct(): https://www.mathworks.com/help/matlab/ref/writestruct.html in R2020b. If you have R2020b, you can directly write the struct in a text file.
更多回答（2 个）
Sudhakar Shinde
2020-9-29
You can try this:
load Structure_Example.mat
writetable(struct2table(PracTrials), 'Structure_Example.csv')
The output csv file snal looks as below:
5 个评论
Kathrin Sadus
2020-9-29
Sudhakar Shinde
2020-9-29
Hellon Kathrin,
The multidimentional data available in structure as highlighted.
Creating a table from struct is working perfectly. This multidimentional data is now available in cell array in table.
struct2table(PracTrials)
And reaon of improper data in csv file is:
For more info:
Sudhakar Shinde
2020-9-29
编辑：Sudhakar Shinde
2020-9-29
You could convert structure into cell array and then write cell into csv. It writes cell data perfectly in csv file.
Converting into cell array, will miss the headers. so you need to work on headers to get perfectly in csv file.
table1=struct2cell(PracTrials);
writecell( table1, 'PracTrials3.csv')
%%Alternatively try for
S=struct2table(PracTrials);
table=table2cell(S);
writecell( table, 'PracTrials2.csv')
Kathrin Sadus
2020-10-21
Aneesha
2021-12-3
can you show the format of PracTrails
Mohammad
2022-3-2
0 个投票
Hi,
I tried to used the same method to convert my struct mat file (attached) but failed. Any help is appreciated.
类别
在 帮助中心 和 File Exchange 中查找有关 Text Files 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
