clc
clear
b=zeros(36,1);
ts = xlsread('ArrowHead_TRAIN.xlsx');
l=length(ts);
 for i = 1:36
     p=ts(i,:);
           fa = movstd(p,20,1);
               secarray=movstd(fa,20,1);
            k=maxk(secarray,10);
      mpt=find(p);
mp=p(mpt(round(numel(mpt)/2)));
G=min(abs(mp-k));
[~,ii] = min(abs(p(:) - k(:)'));
out = p(unique(ii));
for i = 1 : size(ts,1)
    b = 30;
    p = ts(i,:);
    n = numel(p);
    Z = mat2cell(p, 1, diff([0:b:n-1,n]));
 end
A = [];
for ii = 1:length(Z)
      if any(ismember(Z{ii},out)) 
       if (k-mp<=G+l/2)
        A{end+1} = Z{ii}; 
     aa =  ii;
       end
    end
end
z=Z{ii};
idx=p(1:1); 
q=[idx z];
data = q;
    cellReference = sprintf('A%d', i);
    xlswrite('tra.xlsx', data, 1, cellReference);
   end
I used the above code for getting the datasets.How can I write all the needed rows in excel.


