writing excel file for every iterations

clc
clear
clc
A=xlsread('term.xlsx');
[p,q]=size(A);
X=A(:,1);
B = A(:,3);
D=[];
  for i= 1:200:2001 
       X(i)=A(i,1);
       B(i)= A(i,3);
       D=[D;X(i),B(i)]
  end
xlswrite('abc.xlsx',D)

by using this code am only getting last value in my ecel sheet. i want result for every results. could anyone help me thanks in advance musthafa

Answer 1

[Azzi Abdelmalek]

clc
clear
clc
A=xlsread('term.xlsx');
[p,q]=size(A);
X=A(:,1);
B = A(:,3);
D=[];
  for i= 1:200:2001 
       X(i)=A(i,1);
       B(i)= A(i,3);
       D=[D;X(i),B(i)]
  end
xlswrite('abc.xlsx',D)

%or you can do it simply this way

A=xlsread('term.xlsx');
D=A(1:200:2001,[1 3])
xlswrite('abc.xlsx',D)

[mohammed musthafa]

thank you sir. this was what exactly i want