我是新手。尝试使用下面的方法将用户输入从我的多个tkinter GUI写入Excel文件,但最新的值仍被覆盖。我无法将以前的输入值从用户保存到Excel。请你帮忙。我已经使用numovm()创建了许多tkinter窗口,相应地GUI将被创建,然后用户将通过GUI输入值。在
from tkinter import *
import xlwt
# designing window for vmdetails
def Vmdetails():
global vmdetails_screen
for i in range(1,N+1):
t=i
numb=str(t)
vmdetails_screen = Toplevel(numofvm_screen)
vmdetails_screen.title("VM_Details_"+ numb)
vmdetails_screen.geometry("400x950")
global cluster_name
global vm_template
global clustername_entry
# Set text variables
cluster_name = StringVar()
vm_template = StringVar()
# Set label for user's instruction
Label(vmdetails_screen, text="Please enter details below", bg="blue").pack()
Label(vmdetails_screen, text="").pack()
Cluster_Name_lable = Label(vmdetails_screen, text="Cluster_Name "+ numb +"* ")
Cluster_Name_lable.pack()
# Set textvariables entry
clustername_entry = Entry(vmdetails_screen, textvariable=cluster_name)
clustername_entry.pack()
Button(vmdetails_screen, text="Submit", width=10, height=1, command=check).pack()
def check():
# Retrieve the value from the entry and store it to a variable
global var
if cluster_name.get() == '':
invalid_value()
else:
write_to_xls()
def invalid_value():
global invalid_value_screen
invalid_value_screen = Toplevel(vmdetails_screen)
invalid_value_screen.title("Invalid Entry")
invalid_value_screen.geometry("250x100")
Label(invalid_value_screen, text="Enter valid values for all the required fields").pack()
Button(invalid_value_screen, text="OK", command=delete_invalid_value).pack()
def delete_invalid_value():
invalid_value_screen.destroy()
# designing window to provide the number of vm's to be created
def numofvm():
global numofvm_screen
numofvm_screen = Toplevel(main_screen)
numofvm_screen.title("VM_NUM")
numofvm_screen.geometry("300x250")
global vmnumber
global vmnumber_entry
vmnumber = StringVar()
Label(numofvm_screen, text="Please enter the Number of VM's you wishes to create ", bg="blue").pack()
Label(numofvm_screen, text="").pack()
vmnumber_lable = Label(numofvm_screen, text="Number of VM's to be created * ")
vmnumber_lable.pack()
vmnumber_entry = Entry(numofvm_screen, textvariable=vmnumber)
vmnumber_entry.pack()
Button(numofvm_screen, text="Submit", width=10, height=1, command=screen_duplicate).pack()
def screen_duplicate():
global N
N = int(vmnumber.get())
if N > 0 :
Vmdetails()
#exporting the user inputs into an excel sheet
def write_to_xls():
# create new workbook
wb = xlwt.Workbook()
for i in range(1,N+1):
t=i
numb=str(t)
# add sheet using given name
ws = wb.add_sheet("VM_"+numb+"_DETAILS")
# write text to cell
ws.write(0, 0, "Cluster_Name")
ws.write(1, 0,cluster_name.get())
# save to given file name
wb.save('my_file.xls')
def main_account_screen():
global main_screen
main_screen = Tk()
main_screen.geometry("300x250")
main_screen.title("Welcome")
Label(text="Select Your Choice", bg="blue", width="300", height="2", font=("Calibri", 13)).pack()
Label(text="").pack()
Button(text="Enter", height="2", width="30", command=numofvm).pack()
Label(text="").pack()
main_screen.mainloop()
main_account_screen()
正如我在一篇评论中所解释的,数据写入问题是因为您需要存储
StringVar
s,相关信息是list
,而不是只使用单个值变量来覆盖前面的值。在虽然不需要这样做就可以解决这个问题,但是使用这么多全局变量会使代码很难理解、调试和修改,这都是人们普遍认为尽量避免使用这些变量的原因。在
下面是问题中代码使用的列表:
cluster_name
,clustername_entry
,vm_template
,vmdetails_screen
,invalid_value_screen
,numofvm_screen
,vmnumber
,vmnumber_entry
,N
,main_screen
因为这是相当多的,所以我决定在下面的代码中也消除它们,以使设计“更干净”,除了按照建议只显示如何将数据存储在
list
s中之外。希望这将为您的应用程序的持续发展提供更好的基础。在为了避免
global
,它们中的大多数都被转换成一个类的属性,这个类代表了整个应用程序,这是一个基于tkinter guru@Bryan Oakley提出的另一个tkinter
问题的设计。在相关问题 更多 >
编程相关推荐