[num,txt,raw] = xlsread(‘F:\2021.2.11\data_excel.xlsx’);
raw
size(raw,1)
m=1;
for i=1:size(raw,1)
if(isnan(raw{i,1}))
a(m)=i;
m=m+1;
end
end
a=fliplr(a)
for i=1:size(a,2)
raw(a(i),:)=[];
end
raw
[num,txt,raw] = xlsread(‘F:\2021.2.11\data_excel.xlsx’);
raw
size(raw,1)
m=1;
for i=1:size(raw,1)
if(isnan(raw{i,1}))
a(m)=i;
m=m+1;
end
end
a=fliplr(a)
for i=1:size(a,2)
raw(a(i),:)=[];
end
raw