▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My TH-cam Channel: bit.ly/2UFLKgj bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt! Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN ▶️ Get The Code bit.ly/3fLFQ8p
This is an amazing video!! I recently completed two of your courses ( Tkinter and OpenPyXL) and this video provided me a good example how these two libraries can work together for good stuff. I was wondering if you have some tutorial on how you can use pandas and Tkinter together ?
Looking forward to this corse, i have a project for work using tkinter and excel and am getting stuck in a few places, joined your codemy club last night, lots of great info!
If it possible to validates in excel sheets in tkinter.if checke the id number .if number is there then print all the details are print in gui .if id is wrong then tell the user id is incorrect. Is it possible in tkinter
Can you explain how to handle excel macros(creating a button for a repeating task) using python Ex:- Macros Copying one cell value to another By the help of python script.we have to control that button .If we click that it copies value of current cell to other
I have created an output file of a calculation performed in a Tkinter app. But, I am struggling to export the output file in a .xlsx format to a different directory outside the current working directory where the python file exists. Could you please help?
@@Codemycom Thanks for your response. I did add the path to the fd.asksaveasfilename command, but it creates two different files, at the two different locations (one containing the calculations in the directory of the script, and the other in the specified location containing nothing). Is there a way I can write a command to show a pop up window, that asks me where to save the file once the output excel file is created by df.to_excel, instead of automatically saving it to the default folder of the python script.
@@dPten nothing does something twice unless you've written the code to save it twice. I don't know what you're doing but this should be a simple thing for you to tweak. Look at your code.
I'm stuck trying to develop a GUI that simply import a directory of an excel file (new data) then when I click a button, the command function is to amend the information on this (new data) excel file into the maximum row of a (source data) excel file. I used the dataframe and .amend method after converting the two excel sheets to a data frame. However, this might not be good, the (new data) excel might come up with no heading orders like the source data file to amend the information. Any help?
How can i use a better gui style(modern look) in tkinter. I made a project in which i created buttons using image but other stuff like Entrys didn't match the theme. And also tell how to use coordinate system properly. Thanks.
How would you return an individual cell value instead of the whole column? I tried column_a = ws[ 'A2' ] and column_b = ws[ 'B3' ]. And kept everything else the same.
Je n'y comprends pas grand chose, mais j'essaie d'apprendre afin de progresser dans la programmation Python/tkinter, malgré la difficulté de la langue. many thank's.
Sir please get to how to make graphs appear in the same window as the tkinter window and not pop up in another matplotlib window. I know you need to use canvas for that but if you could make a video on the topic that would be great. I know that you are extremely busy but if you could do that as a subscriber request that would be great.
Getting an error as "AttributeError: module 'tkinter' has no attribute 'tk' tried importing tkinter as TK or tk but nothing worked. Tried reinstalling tkinter still an error exists. Anyone can help ?? Thanks in advance for your time
So granting what you say is true (13:00), poor Wilma must, to feed her fella's taste, in lieu of Poobah Mozzarella, find Dino's waste and grabba-dabba poo? Pyew!
▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My TH-cam Channel:
bit.ly/2UFLKgj bit.ly/2IGzvOR
▶️ See More At: ✅ Join My Facebook Group:
Codemy.com bit.ly/2GFmOBz
▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt!
Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN
▶️ Get The Code
bit.ly/3fLFQ8p
this video makes me a python
ha
This is AMAZING and exactly what I was looking for to complete a project this weekend. Thanks!
Glad I could help!
Very useful video! Looking forward to more with excel. Thank you!!
Glad it was helpful!
Brill thank you bro can't wait to try this out myself, really appreciate your tutorials
This is an amazing video!! I recently completed two of your courses ( Tkinter and OpenPyXL) and this video provided me a good example how these two libraries can work together for good stuff. I was wondering if you have some tutorial on how you can use pandas and Tkinter together ?
Smash that like button guys n gals! its free! great python tkinter tutorial, Codemy. Thanks
Looking forward to this corse, i have a project for work using tkinter and excel and am getting stuck in a few places, joined your codemy club last night, lots of great info!
Welcome aboard! That course should be done in about a week, it's been filmed...just need to edit it
Explanations very clear sir...great all ur videos
Glad you like them!
Very clear explanation
Glad you liked it
Excellent! Cheers mate.
Cheers
Hey Great video..
Would you able to advise how to load the data in the window without the button?
call the function in the normal way
@@Codemycom
Hi-
Sorry I don’t know what you mean by this?
Could schedule a short call sometime this week or next please?
@@koys1000 No.
How do you select a non active sheet ?
Love your videos
I’ll go over that in my upcoming course
Excellent. Thank you.
You are welcome!
If it possible to validates in excel sheets in tkinter.if checke the id number .if number is there then print all the details are print in gui .if id is wrong then tell the user id is incorrect. Is it possible in tkinter
sure, that's just basic python if statements
Very useful Thank you very much
Very Welcome
do you have a tutorial merging 2 excel files using python GUI?
nope
awesome bro keep going
always!
Hello professor, I have a question. Can you write data from a GUI in python to an excel file without it being closed?
Sure. I have a whole course on python and excel here:
www.udemy.com/course/python-and-excel-programming-using-openpyxl/?couponCode=JOHN_ELDER11
Can you explain how to handle excel macros(creating a button for a repeating task) using python
Ex:- Macros
Copying one cell value to another
By the help of python script.we have to control that button .If we click that it copies value of current cell to other
Any chance u might be covering grraphics later at some point ??
No idea...I don't know what that is or what it does...
I have created an output file of a calculation performed in a Tkinter app. But, I am struggling to export the output file in a .xlsx format to a different directory outside the current working directory where the python file exists. Could you please help?
just use the full path when saving the file.
@@Codemycom Thanks for your response. I did add the path to the fd.asksaveasfilename command, but it creates two different files, at the two different locations (one containing the calculations in the directory of the script, and the other in the specified location containing nothing). Is there a way I can write a command to show a pop up window, that asks me where to save the file once the output excel file is created by df.to_excel, instead of automatically saving it to the default folder of the python script.
@@dPten nothing does something twice unless you've written the code to save it twice. I don't know what you're doing but this should be a simple thing for you to tweak. Look at your code.
Dangit - exactly what I was looking for and MR. WHITE from Breaking Bad is teaching me?!
I'm stuck trying to develop a GUI that simply import a directory of an excel file (new data) then when I click a button, the command function is to amend the information on this (new data) excel file into the maximum row of a (source data) excel file.
I used the dataframe and .amend method after converting the two excel sheets to a data frame. However, this might not be good, the (new data) excel might come up with no heading orders like the source data file to amend the information.
Any help?
## Import function to amend data from a sheet to an existing resource sheet
def importdata():
df1 = pd.read_excel('Destiny.xlsx', index_col=0)
df2 = pd.read_excel(fileroot, index_col=0)
df1.append(df2, ignore_index= True)
df1 = df1.append(df2)
Saveit = df1.to_excel('/Destiny.xlsx')
importbtn.config(text='Imported', command= NONE, bg='grey')
How can i use a better gui style(modern look) in tkinter. I made a project in which i created buttons using image but other stuff like Entrys didn't match the theme. And also tell how to use coordinate system properly. Thanks.
You can't really. There are themes but they aren't all that useful.
@@Codemycom kindly tell me a library in which i could do that kind of stuff. Thanks.
@@aakashkukal There is no library. You can google "Tkinter themes", but you're probably going to be disappointed
You can use tkinter.ttk
What if i want to check value in first cell of column and if condition is true then only get that data , please provide code or suntax
Use an if statement
How would you return an individual cell value instead of the whole column? I tried column_a = ws[ 'A2' ] and column_b = ws[ 'B3' ]. And kept everything else the same.
I have a course on that at Codemy.com
@@Codemycom I signed up for it! I'll check it out, thank you
Sir how to compare two excel file in tkinter
Syntax for removing duplicates if any in the Excel source data
Je n'y comprends pas grand chose, mais j'essaie d'apprendre
afin de progresser dans la programmation Python/tkinter,
malgré la difficulté de la langue. many thank's.
Sir please get to how to make graphs appear in the same window as the tkinter window and not pop up in another matplotlib window. I know you need to use canvas for that but if you could make a video on the topic that would be great. I know that you are extremely busy but if you could do that as a subscriber request that would be great.
Probably need to use canvas. Might get to it eventually
@@Codemycom Thanks a lot sir.
@@suryanshtokas6337 Sure thing
@@Codemycom Sir thanks you are the best youtuber on python and specially tkinter.
Getting an error as "AttributeError: module 'tkinter' has no attribute 'tk' tried importing tkinter as TK or tk but nothing worked. Tried reinstalling tkinter still an error exists. Anyone can help ?? Thanks in advance for your time
Error got resolved when changing code to :
from tkinter import *
root = tkinter.Tk()
@@PythonCareerCoach yeah it has to be exact, as in all things with coding
@@Codemycom Thank you very much for your reply ❤️
keep getting this error:
ModuleNotFoundError: No module named 'openpyxl'
You need to pip install it on the terminal
So granting what you say is true (13:00),
poor Wilma must, to feed her fella's
taste, in lieu of Poobah Mozzarella,
find Dino's waste and grabba-dabba poo?
Pyew!
lol
I love everything except the heart attacking starting scream of your video.🙃
wippidi woppidi your code is my property
huh? lol
videos are good but u not reply query sir
How so? Lol
First
nice!
Codemy.com love your vids
@@DevOverdrive Thanks! Love your comments ;-)