Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python, Tkinter, & Excel
#1
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.
Reply
#2
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
Reply
#3
(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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Openpyxl tkinter search a value in Excel column Heathcliff_1 0 3,212 Dec-02-2020, 04:35 PM
Last Post: Heathcliff_1

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020