Python sqlite3 tkinter。运行查询，添加列并保存到xlsx

import sqlite3
from tkinter import *

# 创建数据库连接
conn = sqlite3.connect('database.db')
cursor = conn.cursor()

# 执行查询操作
cursor.execute("SELECT * FROM table_name")

# 获取查询结果
results = cursor.fetchall()

# 关闭数据库连接
conn.close()

# 创建窗口
window = Tk()

# 创建文本框
text_box = Text(window)

# 在文本框中显示查询结果
for row in results:
    text_box.insert(END, str(row) + "\n")

# 显示文本框
text_box.pack()

# 运行窗口
window.mainloop()

from openpyxl import Workbook

# 创建工作簿
workbook = Workbook()
sheet = workbook.active

# 添加列名
column_names = [description[0] for description in cursor.description]
for i, column_name in enumerate(column_names):
    sheet.cell(row=1, column=i+1, value=column_name)

# 添加查询结果
for row_index, row in enumerate(results):
    for column_index, value in enumerate(row):
        sheet.cell(row=row_index+2, column=column_index+1, value=value)

# 保存工作簿
workbook.save('output.xlsx')