Feb-03-2017, 01:15 PM
Hi, I'm new in python.
I stole this code here and i need adat it.
How save data in existing excel file (below last data)
I need a function to save into excel.
I stole this code here and i need adat it.
How save data in existing excel file (below last data)
I need a function to save into excel.
from tkinter import * class GUI: def __init__(self, master): self.master = master master.title("Torneio de Sinuca...") self.var = IntVar() self.label = Label(master, textvariable=self.var) self.label.pack() self.listbox = Listbox(master) self.listbox.pack() self.var.set(self.listbox.size()) self.element = StringVar() self.Entry = Entry(master, textvariable=self.element) self.Entry.pack() self.close_button = Button(master, text="Adicionar", command=self.test) self.close_button.pack() def test(self): if len(self.element.get()) != 0: value1 = (self.element.get()) self.listbox.insert(END, value1) #shows how many items in list #print (self.listbox.size()) self.var.set(self.listbox.size()) self.Entry.delete(0, END) def howSaveExistingExcelFile(): # I need save data (name inside listbox) into excel, below last data root = Tk() my_gui = GUI(root) root.geometry("230x250") root.mainloop()I find it
from xlrd import open_workbook from xlwt import Workbook from xlutils.copy import copy rb = open_workbook("Login.xls") wb = copy(rb) s = wb.get_sheet(0) s.write(0,0,'A1') #This code save ever on first cell, I need save below last row wb.save('Login.xls')Thank you!!