The data that saves into the excel file comes out like this
User Name Password
User1 password
ser1 assword
er1 ssword
r1 sword
1 word
ord
rd
d
instead of just being one entry
What I have tried:
The functions i used to save the entered data
def setCredentials(self):
username = self.eUSER.get()
password = self.ePASS.get()
print("username", username)
print("password", password)
def insert(self) :
current_row = sheet.max_row
if (self.eUSER.get() == "" and
self.ePASS.get() == "" ):
print("empty input")
return
else :
sheet.cell(row=current_row + 1, column=1).value = self.eUSER.get()
sheet.cell(row=current_row + 1, column=2).value = self.ePASS.get()
self.eUSER.bind("<Return>", self.focusU)
self.ePASS.bind("<Return>", self.focusP)
self.eUSER.grid(row=1, column=1, ipadx="100")
self.ePASS.grid(row=2, column=1, ipadx="100")
sheet.column_dimensions['A'].width = 40
sheet.column_dimensions['B'].width = 40
sheet.column_dimensions['C'].width = 40
sheet.cell(row=1, column=1).value = "User Name"
sheet.cell(row=1, column=2).value = "Password"
sheet.cell(row=1, column=3).value = "Security question"
wb.save(r'C:\Users\Hennie\Desktop\new\sheet.xlsx')
self.clear()
self.eUSER.focus_set()
self.insert()
return
When button clicked to call the functions
self.LOGIN = tk.Button(self, text = "Create new user", fg="black", command =lambda :[self.setCredentials(), self.insert()])