What can I use for equality test between input arguments of type cell?
3 views (last 30 days)
Show older comments
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!!
0 Comments
Accepted Answer
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)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!