matlab读取excel，对往年高考投档志愿进行筛选，作为填志愿的参考

clc;clear;close all;
[num,txt,raw]=xlsread('E:\2-Working file\WE\投递志愿\2022年.xlsx');
newi = 1;
newj = 1;
for i = 2:size(raw,1)
    major = raw{i,1};
    if(contains(major,'材料') || contains(major,'小学')|| contains(major,'化学') || contains(major,'社会')|| contains(major,'市政')...
       || contains(major,'特殊')|| contains(major,'动画')|| contains(major,'维修')|| contains(major,'新闻')|| contains(major,'文秘')...
       || contains(major,'服装')|| contains(major,'邮政')|| contains(major,'助产')|| contains(major,'人力')|| contains(major,'航海')...
       || contains(major,'船舶')|| contains(major,'文物')|| contains(major,'影视')|| contains(major,'模特')|| contains(major,'护理')...
       || contains(major,'土木')|| contains(major,'机械')|| contains(major,'英语')|| contains(major,'公费')|| contains(major,'心理')...
       || contains(major,'电子商务')|| contains(major,'法律')|| contains(major,'化工')|| contains(major,'殡葬')|| contains(major,'轮机')...
       || contains(major,'动漫')|| contains(major,'播音')|| contains(major,'直播')|| contains(major,'焊接')|| contains(major,'财富')...
       || contains(major,'园林')|| contains(major,'动漫')|| contains(major,'旅游')|| contains(major,'酒店')|| contains(major,'水利')...
       || contains(major,'园艺')|| contains(major,'传播')|| contains(major,'策划')|| contains(major,'资产')|| contains(major,'保险')...
       || contains(major,'社区')|| contains(major,'文化')|| contains(major,'道路')|| contains(major,'桥梁')|| contains(major,'连锁')...
       || contains(major,'古建筑')|| contains(major,'行政')|| contains(major,'电子竞技')|| contains(major,'医疗')|| contains(major,'化妆品')...
       || contains(major,'医美')|| contains(major,'广告')|| contains(major,'艺术')|| contains(major,'知识')|| contains(major,'产权')...
       || contains(major,'客运')|| contains(major,'高分子')|| contains(major,'民政')|| contains(major,'港口')|| contains(major,'宝石')...
       || contains(major,'陶瓷')|| contains(major,'工艺')|| contains(major,'党务')|| contains(major,'营养')|| contains(major,'房地产')...
       || contains(major,'检修')|| contains(major,'慈善')|| contains(major,'修理')|| contains(major,'兽医')|| contains(major,'美术')...
       || contains(major,'茶叶')|| contains(major,'旅游')|| contains(major,'集装')|| contains(major,'模具')|| contains(major,'国土')...
       || contains(major,'创业')|| contains(major,'餐饮'))
        shanchu(newj,:) = raw(i,:);
        newj = newj+1;
    else
        newxls(newi,:) = raw(i,:);
        newi = newi+1;
    end
end


newii = 1;
newjj = 1;
for i = 1:size(newxls,1)
    city = newxls{i,2};
    if(contains(city,'海南') || contains(city,'西藏')|| contains(city,'广西') || contains(city,'青海')|| contains(city,'新疆')...
           || contains(city,'甘肃') || contains(city,'宁夏') || contains(city,'海口') || contains(city,'三亚') || contains(city,'西藏') ...
           || contains(city,'四川') || contains(city,'湖北') || contains(city,'湖南') || contains(city,'桂林')...
           || contains(city,'贵州') || contains(city,'广东') || contains(city,'黑龙江') || contains(city,'牡丹江')...
           || contains(city,'重庆') || contains(city,'成都') || contains(city,'长沙') || contains(city,'哈尔滨')...
           || contains(city,'白城') || contains(city,'江西') || contains(city,'南昌') || contains(city,'黄冈')...
           || contains(city,'襄阳') || contains(city,'福建') || contains(city,'福州') || contains(city,'张家界')...
           || contains(city,'武汉')|| contains(city,'广东')|| contains(city,'广州')|| contains(city,'满洲里')...
           || contains(city,'遵义')|| contains(city,'荆楚')|| contains(city,'汉江')|| contains(city,'内蒙')...
           || contains(city,'巴音')|| contains(city,'恒星')|| contains(city,'吉林')|| contains(city,'长春')...
           || contains(city,'兰州')|| contains(city,'云南')|| contains(city,'昆明')|| contains(city,'酒店管理')...
           || contains(city,'荆州')|| contains(city,'山西')|| contains(city,'陕西')|| contains(city,'克拉玛依')...
           || contains(city,'丽江')|| contains(city,'九江')|| contains(city,'和田')|| contains(city,'黔南')...
           || contains(city,'肇庆')|| contains(city,'泉州')|| contains(city,'汉口'))
        shanchu1(newjj,:) = newxls(i,:);
        newjj = newjj+1;
    else
        newxls1(newii,:) = newxls(i,:);
        newii = newii+1;
    end
end