python openpyxl 写excel文件，一个文件里多个子文件

import openpyxl
from openpyxl.styles import Font


def writer_file(file, datas, sheetname):   
    '''
    file: 文件名
    datas: 待写入数据
    sheetname： 子表名
    '''
    i = 1
    xls = openpyxl.Workbook()
    sheet = xls.active
    xls.get_sheet_by_name("Sheet")
    sheet.title = sheetname
    foot = Font(name = "等线", size = 12)  #设置字体格式

    #sheet.cell.font = foot


    for data in datas:
        sheet.cell(i, 1, data[0]).font = foot
        sheet.cell(i, 2, data[1]).font = foot
        sheet.cell(i, 3, data[2]).font = foot
        i += 1
    xls.save(file)

def add_Excel(file, datas, sheet): #追加子表
    wb = openpyxl.load_workbook(file)
    wb.create_sheet(sheet)
    ws = wb[sheet]
    foot = Font(name="等线", size=12)
    i = 1

    for data in datas:
        #ws.append(data)
        ws.cell(i, 1, data[0]).font = foot
        ws.cell(i, 2, data[1]).font = foot
        ws.cell(i, 3, data[2]).font = foot
        i += 1

    wb.save(file)