from openpyxl import load_workbook, Workbook


def write_excel(file_name, data):
    # 打开Excel文件，加载workbook
    flag = False
    try:
        workbook = load_workbook(filename=file_name)
    except FileNotFoundError:
        flag = True
        workbook = Workbook()
    # 根据名称获取worksheet
    worksheet = workbook.active

    if flag:
        worksheet.append(["账号", "充值数", "实际充值数", "充值前余额", "充值后余额"])
    worksheet.append(data)
    workbook.save(filename=file_name)