data1=xlsread('20200816_10_01_46.xlsx','B:O');
data2=data1;
data2( find( isnan(data2) ==1) )=10000; % 把g中第一行中为Nan的替换为100
n=length(data2);
j=1
for i=1:n
if data2(i,1)~=10000
data3(j,1:4)=data2(i,1:4);
j=j+1
end
end
j=1
for i=1:n
if data2(i,5)~=10000
data3(j,5:7)=data2(i,5:7);
j=j+1
end
end
j=1
for i=1:n
if data2(i,5)~=10000
data3(j,8:10)=data2(i,8:10);
j=j+1
end
end
j=1
for i=1:n
if data2(i,5)~=10000
data3(j,11)=data2(i,11);
j=j+1
end
end
for i=1:n
if data2(i,5)~=10000
data3(j,11)=data2(i,11);
j=j+1
end
end