excel数据比对小工具

class excel_compare(QWidget):  def __init__(self):  QWidget.__init__(self) self.compare_ui = excel多功能比对界面.Ui_Form() self.compare_ui.setupUi(self) def excel_true_false():  if window.compare_ui.lineEdit.text() and window.compare_ui.lineEdit_2.text() and window.compare_ui.lineEdit_3.text() and window.compare_ui.lineEdit_4.text() and window.compare_ui.lineEdit_5.text() and window.compare_ui.lineEdit_6.text() and window.compare_ui.lineEdit_7.text():  file_path_original = r''  str(window.compare_ui.lineEdit.text())#转义文件路径，怕有奇葩名字  data_original = xlrd.open_workbook(file_path_original) #获取sheet  table_original = data_original.sheet_by_name(str(window.compare_ui.lineEdit_3.text())) #获取总行数  nrows_original = table_original.nrows #获取总列数  ncols_original = table_original.ncols
        li_original = [] for i in range(1,nrows_original):  # print("333")  cell_value = table_original.cell(i,int(window.compare_ui.lineEdit_4.text()) - 1).value
            li_original.append(cell_value) # print(li_original)  file_path_target = r''  str(window.compare_ui.lineEdit_2.text())
        data_target = xlrd.open_workbook(file_path_target) # 获取sheet  table_target = data_target.sheet_by_name(window.compare_ui.lineEdit_5.text()) # 获取总行数  nrows_target = table_target.nrows # 获取总列数  ncols_target = table_target.ncols # global li_target  li_target = [] for u in range(1, nrows_target):  cell_value = table_target.cell(u, int(window.compare_ui.lineEdit_6.text()) - 1).value
            li_target.append(cell_value) # print(li_target)  # print(li_target)  # file_path_original = r'E:\python项目\EXCEL对比\test.xls'  # w_sheet = wbook.get_sheet(0)  # 索引sheet表  # print("123")  original_file = pd.ExcelFile(file_path_original)
        original_sheetnames = original_file.sheet_names # print(original_sheetnames)  for original_sheetnames_index in range(0,len(original_sheetnames)):   if window.compare_ui.lineEdit_3.text() == original_sheetnames[original_sheetnames_index]:  original_sheetnames_INDEX = original_sheetnames_index
        rbook = xlrd.open_workbook(file_path_original) # 打开文件  wbook = copy.copy(rbook) # 复制文件并保留格式  w_sheet = wbook.get_sheet(original_sheetnames_INDEX) # 索引sheet表  a = int(window.compare_ui.lineEdit_7.text()) - 1  for index in range(0,len(li_original)):  if li_original[index] in li_target:  w_sheet.write(index 1,a, "true") else:  w_sheet.write(index  1,a, "false")
        wbook.save(file_path_original) # 保存文件  root = tk.Tk()
        root.withdraw()
        msgbox.showerror(title="提示", message="比对完成") else:  root = tk.Tk()
        root.withdraw()
        msgbox.showerror(title="警告", message="有数据没有输入或数据输入错误!")