1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| 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)
|
|
