Apr-29-2022, 03:37 PM
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.
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.