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.