openxlpy读写excel要比pandas快

openxlpy读写excel要比pandas快一点的，尽管代码复杂些。

else:# 如果条码重复，添加记录并登记接收
    row = df.loc[df['Barcode'] == CODE] 
    if pd.isna(row['Receive'].values[0]) :  
       if is_on_UFH() == True : 
          current_time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') 
          df.loc[df['Barcode'] == CODE,'Receive'] = computer_name  
          df.loc[df['Barcode'] == CODE, 'RecTime'] = current_time  时间
          df.to_excel(file_name, index=False)  # 将df保存到Excel文件中
          df.to_html(backup_htm)
          shutil.copyfile(file_name, backup_file_name)  # 备份xlsx文件

04139708607
Elapsed time: 0.04468226432800293 seconds

else:
   for row_index, row in enumerate(ws.iter_rows(values_only=True), start=1):
      if row[0] == CODE and row[3] is None:
         if