Excel Type Forms in Python

Question

Excel Type Forms in Python

(OP)

13 Sep 19 04:16

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

S&T

Agent666 (Structural) · Answer 1 · 2019-09-13 05:12:00

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

Celt83 (Structural) · Answer 2 · 2019-09-13 13:01:47

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 (Structural) · Answer 3 · 2019-09-13 14:13:40

RE: Excel Type Forms in Python

sticksandtriangles (Structural)

(OP)

13 Sep 19 14:13

Thank you! I will dig into these.

S&T

IDS (Civil/Environmental) · Answer 4 · 2019-09-14 12:06:25

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 (Structural) · Answer 5 · 2019-09-16 15:03:49

@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

Answer 6

[Post Deleted]

Celt83 (Structural) · Answer 7 · 2019-09-18 18:00:09

@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 (Civil/Environmental) · Answer 8 · 2019-09-19 04:55:57

Quote:

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 (Structural) · Answer 9 · 2019-09-19 14:16:23

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

Come Join Us!

Posting Guidelines

Related Projects

Excel Type Forms in Python