如下所示：

# -*- coding:utf-8 -*-import xlrdimport sysimport reimport jsondict1={}dict2={}mylist=[u'系統(tǒng)運(yùn)維管理',u'安全管理機(jī)構(gòu)',u'安全管理制度',u'人員安全管理',u'網(wǎng)絡(luò)安全',u'物理安全',u'網(wǎng)絡(luò)安全',u'主機(jī)安全',u'應(yīng)用安全',u"網(wǎng)絡(luò)安全",u"主機(jī)安全",u"主機(jī)安全",u'系統(tǒng)建設(shè)管理']def check():  data=xlrd.open_workbook('test.xls')  for i in range(0,13):    print u"第%s個(gè)表格"%(i+1)    print mylist[i]    print "-"*60    try:      table=data.sheets()[i]    except IndexError,e:      break      nrows=table.nrows    count=1    if i<5:      m=10    else:      m=16    for j in range(m,nrows):      cell_1=table.cell(j,2).value      #print cell_1,      cell_2=table.cell(j,3).value      nu=re.split(r'/)',cell_2)      num=re.split(r'/）',nu[0])      if num is not None:        #print num[0],        pass      else:        print u"沒有標(biāo)記序號(hào)"      try:        if j<nrows:          if table.cell(j,2).value==table.cell(j+1,2).value:            count+=1          else:            print u"檢查項(xiàng)【%s】共有【%s】項(xiàng)"%(table.cell(j,2).value,count)            key=mylist[i]+table.cell(j,2).value            dict1[key]=count            count=1        else:          count+=1          print u"檢查項(xiàng)【%s】共有【%s】項(xiàng)"%(table.cell(j,2).value,count)          key=mylist[i]+table.cell(j,2).value          dict1[key]=count              except IndexError,e:        #count+=1        print u"檢查項(xiàng)【%s】共有【%s】項(xiàng)"%(table.cell(j,2).value,count)        key=mylist[i]+table.cell(j,2).value        dict1[key]=count    print "-"*60  print json.dumps(dict1, encoding='UTF-8', ensure_ascii=False)  print u"完成excel表格讀取-Thanks"def ASGcheck(filename):  data=xlrd.open_workbook(filename)  table=data.sheets()[0]  print "-"*60   nrows=table.nrows  count=1  for j in range(1,nrows):    cell_1=table.cell(j,2).value    #print cell_1,    cell_2=table.cell(j,3).value    nu=re.split(r'/)',cell_2)    num=re.split(r'/）',nu[0])    if num is not None:      #print num[0],      pass    else:      print u"沒有標(biāo)記序號(hào)"    try:      if j<nrows:        if table.cell(j,3).value==table.cell(j+1,3).value:          count+=1        else:          print u"安全層面【%s】檢查項(xiàng)【%s】共有【%s】項(xiàng)"%(table.cell(j,2).value,table.cell(j,3).value,count)          key=table.cell(j,2).value+table.cell(j,3).value          dict2[key]=count          count=1      else:        count+=1        print u"安全層面【%s】檢查項(xiàng)【%s】共有【%s】項(xiàng)"%(table.cell(j,2).value,table.cell(j,3).value,count)        key=table.cell(j,2).value+table.cell(j,3).value        dict2[key]=count          except IndexError,e:      #count+=1      print u"安全層面【%s】檢查項(xiàng)【%s】共有【%s】項(xiàng)"%(table.cell(j,2).value,table.cell(j,3).value,count)      key=table.cell(j,2).value+table.cell(j,3).value      dict2[key]=count  #print json.dumps(dict2, encoding='UTF-8', ensure_ascii=False)  print "-"*60def standard():  choiceA=raw_input(u"請(qǐng)輸入A的等級(jí)：A2，A3，A4")  choiceS=raw_input(u"請(qǐng)輸入S的等級(jí)：S2，S3，S4")  choiceG=raw_input(u"請(qǐng)輸入G的等級(jí)：G2，G3，G4")  Aname=str(choiceA)+".xlsx"  Sname=str(choiceS)+".xlsx"  Gname=str(choiceG)+".xlsx"  check()   def compare():    print "*"*60    for key in dict2:      try:        if dict2[key]!=dict1[key]:          print u"存在異常項(xiàng)"          print u"從程序中導(dǎo)出的檢查項(xiàng)【%s】共有%s項(xiàng)"%(key,json.dumps(dict1[key], encoding='UTF-8', ensure_ascii=False))          print u"從分支查詢的檢查項(xiàng)【%s】共有%s項(xiàng)"%(key,json.dumps(dict2[key], encoding='UTF-8', ensure_ascii=False))        else:          pass            except KeyError,e:        print u"分支中的檢查項(xiàng)【%s】共有%s項(xiàng)"%(key,json.dumps(dict2[key], encoding='UTF-8', ensure_ascii=False)),        print u"程序中沒有查詢到該項(xiàng)"  #比較分支結(jié)果和程序?qū)С龅慕Y(jié)果    ASGcheck(Aname)  compare()  ASGcheck(Sname)  compare()  ASGcheck(Gname)  compare()standard()#ASGcheck('S3.xlsx')