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