exporting a .mat file to csv/ xls

Hi,

Am new here so this may be a dupe query:

I have a 1X1 struct with 2 fields. 1 field has 2000 values of double and the next one has 10000 values as double.

How do i export this type of data into a spreadsheet/ csv.

i tried using writematrix but it gave me the unsupported type 'struct' error.

Thanks

[Stephen23]

How do you want those 2000 + 10000 values arranged in the output file: as one long row vector, as one column vector, as two columns, as two rows, on two different sheets (XLSX only), or something else that you require?

[Amit Sinha]

I would ideally require these on 2 different spreadsheets in an xls.

Answer 1

[Arif Hoq]

you have to extract your data from the struct. here i am giving an example. i have attached a struct

structvalue=load('data2.mat'); % load your struct in matlab
data=structvalue.A  % extract your data
writematrix(data,'myfilename.xlsx')  % export to excel or csv
% you can use writetable also