Excel Type Forms in Python

[sticksandtriangles]

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)?

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?

http://www.blog.pythonlibrary.org/2017/12/14/flask-101-adding-editing-and-displaying-data/

S&T

 

[Agent666]

If you're thinking of building a standalone GUI of sorts, then possibly TkInter?

 

[Celt83]

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:

https://github.com/buddyd16/Structural-Engineering

 

[sticksandtriangles]

Thank you! I will dig into these.

S&T

 

[IDS]

Or you could get Excel style forms by using Excel, and calling Python routines with xlwings, pyxll, or similar.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[sticksandtriangles]

@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


S&T

 

[Celt83]

@Sticks:
On the GUI front it was a lot of googling, youtube watching, and just brute forcing thru some things.

The Learn Python reddit page seems like it has a ton of great information, Link

Open Source Structural Applications:

https://github.com/buddyd16/Structural-Engineering

 

[IDS]

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

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

http://newtonexcelbach.wordpress.com/

 

[sticksandtriangles]

I'm making progress (and it is good learning), I've got a GUI table working with PyQt.

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


S&T