Jan-19-2019, 02:36 PM
I got stuck on this error with my code. Basically I am using openpyxl and tkinter to create a program that stores data in an excel file. Every time I complete the entry boxes and press the button I get AttributeError: 'int' object has no attribute 'reindex'. Here is the code
from tkinter import *
from openpyxl import *
from tkinter import messagebox
wb = load_workbook("C:/Users/PC/Desktop/date.xlsx")
sheet = wb.active
def excel():
sheet.column_dimensions['A']=30
sheet.column_dimensions['B']=30
sheet.column_dimensions['C']=10
sheet.column_dimensions['D']=10
sheet.cell(row=1, column=1).value="Nume"
sheet.cell(row=1, column=2).value="Prenume"
sheet.cell(row=1, column=3).value="Clasa"
sheet.cell(row=1, column=4).value="Nota"
def focus1(event):
prenume_e.focus_set()
def focus2(event):
clasa_e.focus_set()
def focus3(event):
nota_e.focus_set()
def clear():
nume_e.delete(0, END)
prenume_e.delete(0, END)
clasa_e.delete(0, END)
nota_e.delete(0, END)
def insert():
if(nume_e.get()=="" or prenume_e.get()=="" or clasa_e.get()=="" or nota_e.get()==""):
messagebox.showerror("Eroare", "Va rugam introduceti o valoare")
else:
current_row=sheet.max_row
current_column=sheet.max_column
sheet.cell(row=current_row + 1, column=1).value=nume_e.get()
sheet.cell(row=current_row + 1, column=2).value=prenume_e.get()
sheet.cell(row=current_row + 1, column=3).value=clasa_e.get()
sheet.cell(row=current_row + 1, column=4).value=nota_e.get()
wb.save("C:/Users/PC/Desktop/date.xlsx")
nume_e.focus_set()
clear()
if __name__ == "__main__":
root=Tk()
root.configure(background="light blue")
root.title("Formular")
root.geometry("500x300")
excel()
formular = Label(root, text="FORMULAR", font="Helvetica 16 bold", bg="light blue", fg="black")
nume = Label(root, text="Nume: ", font="Helvetica 14 bold", bg="light blue", fg="black")
prenume = Label(root, text="Prenume: ", font="Helvetica 14 bold", bg="light blue", fg="black")
clasa = Label(root, text="Clasa: ", font="Helvetica 14 bold", bg="light blue", fg="black")
nota = Label(root, text="Nota: ", font="Helvetica 14 bold", bg="light blue", fg="black")
formular.grid(row=0, column=1)
nume.grid(row=1, column=0)
prenume.grid(row=2, column=0)
clasa.grid(row=3, column=0)
nota.grid(row=4, column=0)
nume_e = Entry(root)
prenume_e = Entry(root)
clasa_e = Entry(root)
nota_e = Entry(root)
nume_e.bind("<Return>", focus1)
prenume_e.bind("<Return>", focus2)
clasa_e.bind("<Return>", focus3)
nume_e.grid(row=1, column=1, ipadx="100")
prenume_e.grid(row=2, column=1, ipadx="100")
clasa_e.grid(row=3, column=1, ipadx="100")
nota_e.grid(row=4, column=1, ipadx="100")
excel()
confirmare = Button(root, text="CONFIRMARE", fg="red", bg="white", command=insert)
confirmare.grid(row=5, columnspan=2)
root.mainloop()I searched everywhere for this error and I didn't get it solved.
