【原】Python修改Excel文件

```python3

import openpyxl

# 创建workbook对象

workbook = openpyxl.Workbook()

sheet = workbook.active

# 修改表单名称

sheet.title = "设置的表单名称"

# 创建表单

workbook.create_sheet(index=1, title="第二张表")

# 删除表单

workbook.remove_sheet(workbook.get_sheet_by_name("Sheet3"))

# 输出工作簿中所有表单名字

print(workbook.get_sheet_names)

# 修改单元格值

sheet["A1"] = "New Value"

# 修改完毕保存到文件

workbook.save("created.xlsx")

# 批量写入

import openpyxl

from openpyxl.utils import get_column_letter, column_index_from_string

workbook = openpyxl.Workbook()

# 方法一

ws1 = workbook.create_sheet("第一页")

for row in range(40):

    ws1.append(range(17))

workbook.save("created.xlsx")

# 方法二

ws2 = workbook.create_sheet("第二页")

rows = [

    ["Number", "Batch1", "Batch2"],

    [2,40,30],

    [3,50,25],

    [4,30,30],

    [5,60,10],

    [6,40,30]

]

for row in rows:

    ws2.append(row)

workbook.save("created.xlsx")

# 方法三

ws3 = workbook.create_sheet("第三页")

for row in range(5,30):

    for col in range(15,24):

        ws3.cell(column=col, row=row, value=123)

workbook.save("created.xlsx")

```