Open Excel Spreadsheets In Treeview - Tkinter Projects 3

In this video I'll show you how to open an Excel .xlsx file into a Treeview widget with Tkinter and Python!
We'll use Pandas, Numpy, TTK Treeview, and customTkinter to do this.
You may also need to pip install openpyxl to make this work.
#tkinter #codemy #JohnElder
Timecodes
0:00​​ - Introduction
1:27 - Install and Import Numpy and Pandas
2:09 - Import ttk, filedialog, messagebox
2:33 - Build Out Our GUI
3:48 - Open File With FileDialog
5:30 - Create Excel DataFrame With Try/Except
6:25 - Error Handling
7:53 - Clear The Treeview
8:34 - Get Headers
10:40 - Show Excel Data In Treeview
12:09 - Style Treeview
14:45 - Hack Treeview Header Height
15:51 - Change Treeview Header Color
16:43 - Conclusion

[@TkinterPython]

▶ Watch Tkinter Projects Playlist ✅ FREE Tkinter Widget Book bit.ly/3AeVo0d bit.ly/3K4qlZC ▶ See More At: ✅ Subscribe To My KZbin Channel: Tkinter.com bit.ly/3Pk1By4 ▶ MASSIVE TKINTER.COM DISCOUNT ✅ Join My Facebook Group: 30% off with coupon code: youtube bit.ly/2GFmOBz ▶ Get The Code For This Video bit.ly/3dCzz2K

[@thebuggser2752]

Very nice application! Thanks! I especially like the change the row height hack. Clever.

[@TkinterPython]

Thanks!

[@georgecodeing7907]

thank u so much for the helpful videos .... cant wait for more

[@TkinterPython]

More coming soon!

[@alfredomolina2697]

Hi, is a great video very constructive, thank you

[@TkinterPython]

Welcome!

[@obulnaidu3464]

Thank you so much

[@TkinterPython]

Very welcome!

[@sebsincognito]

great video! does it work with csv files?

[@grif5332]

You have an amazing teaching style. I do not have much knowledge in tkinter ...or python for that matter (as i am still learning this for work). But, I understood everything and am super excited to learn this further! Thank you! :)

[@TkinterPython]

Awesome! Keep it up!

[@user-rr2vs8zl4u]

Thank you~~As Always~~!!

[@manarmimi3073]

Thank you cir

[@TkinterPython]

Welcome!

[@el_munoz]

I realize that we can rid the #0 column in the Treeview fill data loop. Thanks!

[@TkinterPython]

Sure thing!

[@Eirstream]

@TkinterPython nice video, please say: how to edit and values at the treeview??? thank you

[@TkinterPython]

I have videos on the channel that teach that

[@ayushmuley1907]

Thanks

[@TkinterPython]

Welcome!

[@angeljimenex880]

Tengo problemas con List

[@jiovanniabdelmalak296]

need the other half of the video!

[@TkinterPython]

What other half? What do you mean? The video is complete.

[@pc-kn7kt]

i get value from excel to treeview but integer showing with decimal value. i dont want decimal value, i tried many ways but it showing like 1.0 what to do

[@pc-kn7kt]

got it. exceltrv1.heading('a', text="a", anchor=W) for row in dftoken.iterrows(): a= row[1]['a'] exceltrv1.insert("", 0, values=(int(a)))

[@marcelledibondji4215]

Hi , thanks for the video . I tried the same code but it seems like I can’t read excel files . I have the following error message : UnicodeDecodeError: ´utf-8 code can’t decode byte 0xec in position 14: invalid continuation byte ‘. Can you help me please ?

[@TkinterPython]

What did google tell you when you googled the error?

[@GyanSingh-xc6gt]

Good sir