What can I use for equality test between input arguments of type cell?

2 views (last 30 days)
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!!

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 3 Dec 2012
Edited: Andrei Bobrov on 3 Dec 2012
use
if strcmp(Normal{i},Patient_ID{j})
try variant of solution
[num, txt] = xlsread('ExcelMainExport_ALL.xls');
ii = ismember(txt1(2:end,1),Normal);
out = txt([false; ii],:);
xlswrite('Data_Collected_Normal.xls', out);

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!