如何使用python创建包含多个工作表的excel文件以存储文本文件的内容？

pip install openpyxl

import openpyxl

workbook = openpyxl.Workbook()

worksheet1 = workbook.active
worksheet1.title = "Sheet1"

worksheet2 = workbook.create_sheet(title="Sheet2")

with open("text_file.txt", "r") as file:
    lines = file.readlines()
    for i, line in enumerate(lines):
        worksheet1.cell(row=i+1, column=1).value = line.strip()

workbook.save("output.xlsx")

import openpyxl

workbook = openpyxl.Workbook()
worksheet1 = workbook.active
worksheet1.title = "Sheet1"

worksheet2 = workbook.create_sheet(title="Sheet2")

with open("text_file.txt", "r") as file:
    lines = file.readlines()
    for i, line in enumerate(lines):
        worksheet1.cell(row=i+1, column=1).value = line.strip()

workbook.save("output.xlsx")