+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Python, Tkinter, & Excel (/thread-37076.html)
Python, Tkinter, & Excel - Extra - Apr-29-2022
Hello,
I'm looking to build a simple inventory system to keep track of my parts and I was browsing the internet for ideas on how to do it when I found a couple videos on how to build an inventory on python and some videos showing an inventory system using excel.
I was wondering If it's possible for me to build my inventory system in excel use tkinter as a GUI interface for it via python. (So basically, link my spreadsheet to python and tkinter). That way I can have a user friendly GUI that directly affects the spread sheet database. (For example, If I add a widget in stock through the GUI, it's added to the spread sheet. If I remove the widget through the GUI the quantity of that widget is updated on the spreadsheet).
Can this be done? If so, how would I go about doing it?
Thanks in advance.
RE: Python, Tkinter, & Excel - Larz60+ - Apr-29-2022
here's a similar (python and excel) project.
It's for stock prices, but should give you some ideas: https://finage.medium.com/how-to-collect-stock-data-into-excel-with-python-a25fea7d903
RE: Python, Tkinter, & Excel - Extra - Apr-29-2022
(Apr-29-2022, 10:36 PM)Larz60+ Wrote: here's a similar (python and excel) project.
It's for stock prices, but should give you some ideas: https://finage.medium.com/how-to-collect-stock-data-into-excel-with-python-a25fea7d903
Thanks, I'll look into it.