xlsx追加写入内容

import os
import openpyxl


# xlsx追加写入内容
# value_list=[[],[],[]]会更快，减少了excel文件的打开保存
def write_excel_xlsx_append(path, sheet_name=‘summary‘, value_list=[[]]):
    # 判断文件是否存在
    if not os.path.exists(path):
        # 创建一个workbook 设置编码
        workbook = openpyxl.Workbook()
        workbook.create_sheet("summary", 0)
        workbook.create_sheet("bugid", 1)
        workbook.remove(workbook[‘Sheet‘])
        # 创建表summary
        summary=workbook[‘summary‘]
        title=[‘Date‘, ‘Result‘, ‘Combination‘, ‘Target‘, ‘Data_Type‘, ‘Duration‘, ‘Testcase‘]
        summary.append(title)
        # 保存文件
        workbook.save(path)
        # print(f‘文件{path}不存在，创建新表格‘)
    if len(value_list) != 0:
        workbook = openpyxl.load_workbook(path)
        for line in value_list:
            sheet = workbook[sheet_name]
            sheet.append(line)
        workbook.save(path)  # 保存工作簿
        # print(f"表格 {path}【追加】写入数据成功！")
    pass