openpyxl xlsx追加写入内容

# xlsx追加写入内容
# value_list=[[],[],[]]会更快，减少了excel文件的打开保存
def write_excel_xlsx_append(path, sheet_name='summary', value_list=None):
    if value_list is None:
        value_list = [[]]
    if os.path.exists(path):
        os.remove(path)

    # 创建一个workbook 设置编码
    workbook = openpyxl.Workbook()
    workbook.create_sheet(sheet_name, 0)
    workbook.remove(workbook['Sheet'])
    # 创建表summary
    summary = workbook[sheet_name]
    title = ['中文', '翻译', '检查']
    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