#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
python 更新excel内容
最新推荐文章于 2023-12-11 10:59:40 发布