What can I use for equality test between input arguments of type cell?
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Andrei Bobrov
2012-12-3
编辑:Andrei Bobrov
2012-12-3
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);
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!