转换为excel d

2024-05-08 00:17:16 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在开发一个Tkinter应用程序,它接受输入和输出excel数据。在

我无法获取尺寸条目或任何其他条目字段。我尝试了很多方法,但都没能得到这个条目,这样它就可以保存到excel文件中了。在

在用户选择chair或table之后,我可以对代码进行哪些更改以获取条目?在

最后,当用户选择finishorder时,我希望条目被获取并存储在excel文件中。在

import datetime    
import tkinter as tk
import xlwt as xl

from datetime import datetime

style1 = xl.XFStyle()
style1.num_format_str = "D-MM-YY"

wb = xl.Workbook()

sheet1 = wb.add_sheet("Sheet1", cell_overwrite_ok=True)
sheet1.write(0, 0, datetime.now(), style1)

sheet1.write(0, 1, "Item")
sheet1.write(0, 2, "Size")
sheet1.write(0, 3, "Quantity")

window = tk.Tk()
window.geometry("500x500")
window.title("Furniture order")

item_label = tk.Label(text="Select your item ")
item_label.grid(column= 5, row=0)

class Order:
    def __init__(self, item):
        self.item = item

    def option (self):
        item_label.destroy()
        table_button.destroy()
        chair_button.destroy()

        size_label = tk.Label(text="Enter the size")
        size_label.grid(column=0, row=0)
        color_label = tk.Label(text="Enter the color")
        color_label.grid(column=0, row=1)
        quantity_label = tk.Label(text="Enter the quantity")
        quantity_label.grid(column=0, row=2)

        size_entry = tk.Entry()
        size_entry.grid(column=2, row=0)
        color_entry = tk.Entry()
        color_entry.grid(column=2, row=1)
        quantity_entry = tk.Entry()
        quantity_entry.grid(column=2, row=2)

        done_button = tk.Button(text="Finish the order", command=chair_data)
        done_button.grid(column=1, row=4)

    def get_entry (self):
        chair = Order("Chair")
        size = chair.option()
        size = size.size_entry.get()
        return size

def run_option ():
    chair = Order("Chair")
    chair.option()

def chair_data ():
    chair = Order("Chair")
    size = chair.get_entry()
    sheet1.write(1, 1, "table")
    sheet1.write(1, 2, size)

chair_button = tk.Button(text="Chair", command=run_option)
chair_button.grid(column=0, row=3)

table_button = tk.Button(text="Table", command=run_option)
table_button.grid(column=10, row=3)

wb.save("test2.xls")
window.mainloop()

Tags: textsize条目columnbuttonitemlabeltk