Can you help me with xlswrite?

>> n=10;
for k=1:n;
exp_tmp=['DNA',num2str(k),'=randseq(20);'];
eval(exp_tmp);
xlswrite('C:\Users\BFSL\Desktop\1.xlsx',[strcat('DNA',num2str(k))],strcat('A',num2str(k),:,'B',num2str(k)));
end

I want to make...

1. generate random DNA -> 2. save in excel like this(image below);

but reality is... (below)

can someone help me?

+generating is success

Answer 1

[KSSV]

clc; clear all ;
 n=10;
 exp_tmp = cell(n,2) ;
for k=1:n;
% exp_tmp{k}=['DNA',num2str(k),'=randseq(20);'];
%  exp_tmp{k}=['DNA',num2str(k),' generated sequence',num2str(k)] ;
 exp_tmp{k}=['DNA',num2str(k),' ',randseq(20)] ;
% eval(exp_tmp);
% xlswrite('C:\Users\BFSL\Desktop\1.xlsx',[strcat('DNA',num2str(k))],strcat('A',num2str(k),:,'B',num2str(k)));
end
xlswrite('DB.xls',exp_tmp) ;

[Kyungsun Ha]

thx

[Kyungsun Ha]

then how can I save this

like this?

[Kyungsun Ha]

randseq is function.. (randomly generate DNA sequence)

[KSSV]

Answer edited..