将两个工作表写入新的excel文件

from openpyxl import Workbook

# 创建一个新的excel文件
workbook = Workbook()

# 获取工作表对象
sheet1 = workbook.active
sheet2 = workbook.create_sheet("Sheet2")

# 修改工作表名称
sheet1.title = "Sheet1"

# 在Sheet1中逐个单元格写入数据
sheet1["A1"] = "姓名"
sheet1["B1"] = "年龄"
sheet1["A2"] = "张三"
sheet1["B2"] = 20

# 在Sheet2中使用数组批量写入数据
data = [["姓名", "性别"], ["李四", "男"], ["王五", "女"]]
for row in data:
    sheet2.append(row)

# 保存excel文件
workbook.save("path/to/new_excel_file.xlsx")