Python Forum

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.

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...25fea7d903

(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...25fea7d903

Thanks, I'll look into it.