MATLAB: Can you help me with xlswrite

randseqxlswrite

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

Best Answer

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) ;
Related Question