Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

structured array help

Asked by 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

James on 21 Aug 2011

yes just the 1 field sorry

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 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.

James

Products

No products are associated with this question.

1 Answer

Answer by 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

Fangjun Jiang

Contact us