import xlrd
# @return [file:
# sheet:
def sheetconpare(file_new,file_old):
sheet_arr= ['劳动合同', '试用情况', '执业资格', '职业资格', '学历学位', '职称情况']
workbook_old = xlrd.open_workbook(file_old)
workbook_new = xlrd.open_workbook(file_new)
for key in sheet_arr:
a = workbook_old.sheet_by_name(key)
b = workbook_new.sheet_by_name(key)
# print("+++"+a.name+"1233213")
for x in range(0,4):
try:
if a.col_values(x) != b.col_values(x):
print("+++"+a.name+"1233213")
print(a.col_values(x)[2])
# print(a.col_values(x))
# print(b.col_values(x))
print("old+"+a.col_values(x)+">>>>>new="+b.col_values(x))
except:
pass
# print(workbook_old.sheet_names())
# a = workbook_old.sheet_by_name("人员信息")
# b = workbook_new.sheet_by_name("Sheet3")
# print(a.col_values(0))
# if a == b:
# print(ok)
# print(workbook_old.sheet_by_name("Sheet3"))
todolisrt{数据结构}