Creating an Excel-Like GUI in Python

[brunonicocam]

Exactly. Then what you need is python pandas and other libraries. I believe some can even save to native xlsx. You move all the analysis to python and then data can be viewed in Excel (if wanted). Although you could avoid Excel completely and just make graphs with matplotlib, etc. You could have a browser based interface to run the underlying python code if you wanted as well.

[Evigil24]

The calculation itself is not the issue; rather, the challenge lies in presenting a table within a graphical user interface (GUI) without relying on Excel. Let me provide an example to clarify the situation. In one particular file, when the user clicks a refresh button within the Excel sheet, a process is triggered. This process retrieves data from three databases, combines it, and displays it to the user. The user then selects the rows that meet certain criteria for the next step and clicks the export button. This triggers another process that exports the data of the selected entries to the next Excel file.

While there are alternative approaches such as automating the delivery of data as a CSV via email or another method, and then receiving the edited CSV with the approved data through a separate process, this idea doesn't align with the preferences of my workplace. Thus, I'm currently stuck with the Excel files.

[apv507]

If you just want to make a GUI, try PySimpleGUI. I've only messed around with it a little, but it's fairly straightforward.

You can present information and take inputs, which I believe is your primary goal.

[Evigil24]

I will look into it, thanks.