for row in ws_lirunbiao.iter_rows(): for cell in row: if str(str(cell.value).replace(' ', '')).find("利润总额") != -1: lirunzonge_row = cell.row print("**********") print(lirunzonge_row) break for row in ws_lirunbiao.iter_rows(): for cell in row: if str(str(cell.value).replace(' ', '')).find("本年累计数") != -1 or str(str(cell.value).replace(' ', '')).find( "本年累计金额") != -1: lirunzonge_column = cell.column print(lirunzonge_column) break if lirunzonge_row == 0 or lirunzonge_column == 0: ws_lirunbiao_lirunzonge = 0 else: if ws_lirunbiao.cell(row=lirunzonge_row, column=lirunzonge_column).value != None: ws_lirunbiao_lirunzonge = round(float((str(ws_lirunbiao.cell(row=lirunzonge_row,column=lirunzonge_column).value).replace(',', '')))/1000)