Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Type Forms in Python

Status
Not open for further replies.
sticksandtriangles

sticksandtriangles

Structural
Joined
Apr 7, 2015
Messages
500
Location
US
Does anyone know of a way in python to create editable forms similar to that of excel (see snip below for what I would like the user to see)?

image_d70jqs.png


I am trying to do some post processing from ETABs and wanted to expand the python skill set a little.

From my googling, it looks like maybe flask package might do the trick?




S&T
 
Sort by date Sort by votes
If you're thinking of building a standalone GUI of sorts, then possibly TkInter?
 
Upvote 0 Downvote
Flask is a web framework which would make it "easy" to deploy on a company intranet so folks wouldn't need python installed.

As Agent noted a TkInter GUI with the form table constructed of input fields arranged in a grid system will get you the same result. PyQT GUI can also accomplish the same thing. Stack Overflow post on the topic: Link


Open Source Structural Applications:
 
Upvote 0 Downvote
@Celt83, did you mention you liked a book helping you learn GUIs?

I think I am going to need to call in a little more reinforcing for learning rather than just watching youtube videos/browsing stackoverflow.

Defining of classes and learning to make windows is more challenging than what I anticipated.
Everything I am reading feels like it is written in hieroglyphics [dazed]


S&T
 
Upvote 0 Downvote
Defining of classes and learning to make windows is more challenging than what I anticipated.
Everything I am reading feels like it is written in hieroglyphics
Click to expand...

That's why it makes sense to me to call Python code from Excel, so you don't have to worry about coding graphic interfaces.

Doug Jenkins
Interactive Design Services
 
Upvote 0 Downvote
I'm making progress (and it is good learning), I've got a GUI table working with PyQt.
table_gvhpjc.png


Trying to add some buttons now to auto populate row data.


S&T
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

IDS
  • Locked
  • Question Question
Python in Excel for Microsoft 365 Insiders
Replies
10
Views
3K
hacksaw
hacksaw
AAK18
  • Locked
  • Question Question
Dot product of large dense matrices in Python 3
Replies
3
Views
972
MintJulep
M
sticksandtriangles
  • Locked
  • Question Question
CAD type interface with Web Application
Replies
3
Views
1K
IDS
IDS
michaelwoodcoc
  • Locked
  • Question Question
Python is (in some ways) a total mess! How should I plan to go from here?
Replies
5
Views
990
Mohanlal0488
Mohanlal0488
DesEngineer4
  • Locked
  • Question Question
Need help in finding out X-Y co-ordinates of an image.
Replies
3
Views
970
Agent666
Agent666

Part and Inventory Search

Sponsor

Back
Top