Hey all,
I have to check whether the data I have exists in an excel file or nor and if so I shall copy that row to a new excel file. all my data is of type cell. Here is my code:
[num, txt, raw] = xlsread('ExcelMainExport_ALL.xls'); Patient_ID = txt([2:end],1);
%% Search for Normal
for i = 1:length(Normal)
for j = 1:length(Patient_ID) if Normal(i) == Patient_ID (j) [num1,txt1]=xlsread('ExcelMainExport_ALL.xls',1,sprintf('A%d:IP%d',j)); xlswrite('Data_Collected_Normal.xls', txt1) warning off MATLAB:xlswrite:AddSheet end end
end
where Normal is a 1X70 cell. And my error is in the equality test! Any help!!
Best Answer