如何在Tkinter中将Treeview数据保存为excel文件？

Question

我的Treeview表单中有一些数据绑定到SQLite数据库，我想知道是否有办法将我的Treeview数据保存为计算机中的excel文件

mytree = ttk.Treeview(frame_busqueda, height=19, column=('column1', 'column2', 'column3', 'column4', 'column5', 'column6'), show='headings', style="Custom.Treeview")
            mytree.pack()
style = ttk.Style()

style.configure("Custom.Treeview.Heading",
                             foreground="green", relief="flat", font='arial 10 bold')
style.map("Custom.Treeview.Heading", relief=[('active', 'groove'), ('pressed', 'sunken')])


mytree.heading("#1", text="ID CARD")
mytree.column("#1", minwidth=0, width=103, stretch=NO)
mytree.heading("#2", text="NAME")
mytree.column("#2", minwidth=0, width=200, stretch=NO)
mytree.heading("#3", text="SURNAME") 

def savetreeview():
     with open("new.csv", "w", newline='') as myfile:
          csvwriter = csv.writer(myfile, delimiter=',')

          for row_id in mytree.get_children():
              row = mytree.item(row_id)['values']
              csvwriter.writerow(row)
              print(row)

我试图使用csv获取行，它将所有Treeview数据显示为输出，但实际上我想要的是将Treeview的数据保存为计算机中的excel文件。谢谢

Answer 1

def saveExcel():
    workbook = load_workbook(filename='problem record.xlsx')
    sheet=workbook['Sheet1']
    sheet.delete_rows(idx=2, amount=15)
    for row_id in treeview.get_children():
        row = treeview.item(row_id)['values']
        sheet.append(row)
    workbook.save(filename='problem record.xlsx')