python 更新excel内容

#coding:utf-8
import os
#读取excel
import xlrd
#写入excel
import xlwt
#复制，分割
from xlutils.copy import copy
import json
from LogFile.logger import Logger
from randoms import RanDom


logger = Logger(logger="excelfile3").getlog()

'''
    @author:dingyanjie
    @date:2020-12-07
    @func:创建更新excel内容
    '''

class ReadExcel:

  def update_excel(self,Excelfile):
      path = os.path.dirname(os.path.abspath('.')) + '\TestData\\'
      # 打开文件
      filepath = path + Excelfile + '.xlsx'
      oldWb = xlrd.open_workbook(filepath,'w+b');  # 先打开已存在的表
      newWb = copy(oldWb)  # 复制excel

      Random_Pact = RanDom()
      # batNo存储随机生成的批次号
      batNo = Random_Pact.batNo()

      newWs = newWb.get_sheet('jinjian')  # 取sheet表
      # 把随机生成的batNo写入到excel并保存
      newWs.write(1, 0, batNo)  # 写入 2行1列写入batNo
      filename='new_jinjian'
      new_filename=path+filename+'.xlsx'
      logger.info('save file name:'+str(new_filename))
      newWb.save(new_filename)  # 保存至新文件路径
      return filename