Using Tkinter to export user input to a .csv file

Question

I have a tkinter code setup that will give the user seven entry prompts, and a "Submit" button. I want to be able to export whatever the user types into the entry box, to a .csv file. I have used the Python tkinter docs, and many other resources, including this website, but cannot find an answer. This is the code i have so far: ``` import Tkinter from Tkinter import * from ttk import * import csv class App(Frame): def tile(): Label(text='Enter Information Below').pack(side=TOP,padx=15,pady=15) def output(self): with open('WorkOrderLog.csv', 'a') as f: w=csv.writer(f, quoting=csv.QUOTE_ALL) Label(text='Name:').pack(side=LEFT,padx=5,pady=5) Entry(root, width=10).pack(side=LEFT,padx=5,pady=5) Label(text='1:').pack(side=LEFT,padx=5,pady=5) Entry(root, width=10).pack(side=LEFT,padx=5,pady=5) Label(text='2:').pack(side=LEFT,padx=5,pady=5) Entry(root, width=10).pack(side=LEFT,padx=5,pady=5) Label(text='3:').pack(side=LEFT,padx=5,pady=5) Entry(root, width=10).pack(side=LEFT,padx=5,pady=5) Lab…

Accepted Answer

You are on the right track using get(), which will return the contents of a tkinter Entry widget.

I have used a single Entry to illustrate how you can accomplish retreiving text from Entry widgets and writing the contents to a .csv file.

```
from tkinter import * 
import csv

class App(Frame):
    def __init__(self, master=None):
        Frame.__init__(self, master)
        self.pack()
        self.output()

def output(self):
        Label(text='Name:').pack(side=LEFT,padx=5,pady=5)
        self.e = Entry(root, width=10)
        self.e.pack(side=LEFT,padx=5,pady=5)

self.b = Button(root, text='Submit', command=self.writeToFile)
        self.b.pack(side=RIGHT,padx=5,pady=5)

def writeToFile(self):
        with open('WorkOrderLog.csv', 'a') as f:
            w=csv.writer(f, quoting=csv.QUOTE_ALL)
            w.writerow([self.e.get()])

if __name__ == "__main__":
    root=Tk()
    root.title('Auto Logger')
    root.geometry('1000x100')
    app=App(master=root)
    app.mainloop()
    root.mainloop()
```

By creating the Entry and assigning it to self.e, you are able to access the text value by calling self.e.get() in the App class' writeToFile function.

Using Tkinter to export user input to a .csv file

Solution

Problem