structured array help

I have a 2x100 structured array

and I want to store and export the values in the 2nd row into Excel. How can I do this?

[Fangjun Jiang]

How many fields does each structure have? Do you want to store all the fields or a particular field? Please provide a 2x3 example.

[James]

<1x1 struct> <1x1 struct> <1x1 struct>

<1x1 struct> <1x1 struct> <1x1 struct>

[Fangjun Jiang]

No. Assume your variable name is a, what is a(1,1),a(1,2),a(1,3),a(2,1),a(2,2),a(2,3)?

[James]

yes

[James]

and i want to store a(2,1) a(2,2) a(2,3) etc

[James]

a(2,1).cdata is just an integer and I want to export all these

[Fangjun Jiang]

Does a have only one field called 'cdata'? That is my question.

[James]

yes just the 1 field sorry

[Fangjun Jiang]

Please accept some of your questions. I believe they are answered. It's a conclude of the post as well as acknowledging that others did help to solve your problem.

[Oleg Komarov]

I stopped answering this poster since he never shows:

- any sign of acknowledgment;

- improvement in the formulation of his questions

- understanding of the fact that an accepted answer is a reference/potential answer for other users as well.

Answer 1

[Fangjun Jiang]

%example data
a(2,9).field1='text'
a(2,9).field2=rand;

%code
prop=fieldnames(a);
N_prop=length(prop);

mat=cell(N_prop,size(a,2));
for k=1:N_prop
    [mat{k,:}]=deal(a(2,:).(prop{k}));
end

xlswrite('test.xls',mat);

%if the data has only one field called .cdata
mat=cell(1,size(a,2))
[mat{1,:}]=deal(a(2,:).cdata);
xlswrite('test.xls',mat);