python修改本地已有excel，不改变原格式

步骤：

1、用load_workbook 读取excel文件

2、写入数据

3、另存为

# 这里是一个df
import pandas as pd
df = pd.read_excel("数据.xlsx")

from openpyxl import load_workbook
workbook = load_workbook(filename = "./模板.xlsx")
sheet = workbook.active

sheet["B1"] = '测试文本'

# 清空目标区域
for i in range(1, 50):
    for j in range(4, 50):
        sheet.cell(row = i,column = j).value = ''

# 写入数据--表头
for j in range(4, 4 + df.shape[1]):
    sheet.cell(row = 2, column = j).value = df.columns[j - 4]

# 写入数据--数据
for i in range(3, 3 + df.shape[0]):
    for j in range(4, 4 + df.shape[1]):
        sheet.cell(row = i,column = j).value = df.values[i - 3][j - 4]

sheet["A1"] = '测试结束'
# 保存excel
workbook.save(filename = "./生成excel.xlsx")