我正在开发一个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()
目前没有回答
相关问题 更多 >
编程相关推荐