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

[Turlough Hughes]

Can you attach the structure to the question?

[Kathrin Sadus]

Sure! It looks like this one here.

Answer 1

[Ameer Hamza]

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.

Answer 2

[Sudhakar Shinde]

You can try this:

load Structure_Example.mat
writetable(struct2table(PracTrials), 'Structure_Example.csv')
 

The output csv file snal looks as below:

[Kathrin Sadus]

Thanks, that was exactly what I was trying, but as soon as I'm using a different structure it seems to fail to convert the table into a csv file. I attached the strcuture and the resulting file.

Again, thanks for helping!

[Sudhakar Shinde]

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:

https://www.mathworks.com/help/releases/R2019b/matlab/ref/writetable.html

[Sudhakar Shinde]

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]

Thank you very much for your help!

[Aneesha]

can you show the format of PracTrails

Answer 3

[Mohammad]

Hi,

I tried to used the same method to convert my struct mat file (attached) but failed. Any help is appreciated.