MATLAB Answers

structured array help

2 views (last 30 days)
James
James on 21 Aug 2011
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?

  10 Comments

Show 7 older comments
James
James on 21 Aug 2011
yes just the 1 field sorry
Fangjun Jiang
Fangjun Jiang on 21 Aug 2011
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
Oleg Komarov on 21 Aug 2011
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.

Sign in to comment.

Answers (1)

Fangjun Jiang
Fangjun Jiang on 21 Aug 2011
%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);

  0 Comments

Sign in to comment.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!