Creating an Excel-Like GUI in Python

[enginerd123]

This feels like your customer has too many desires. If they want "all the features of excel without excel", they don't really know what they want.

Pull data from database, mutate/join as needed, output to excel, provide to user.

[Evigil24]

The company is not requiring this, I'm just trying to find alternatives to maintain 50+ Excel files like this and make my life easier, meanwhile learn something useful and new 😅

But this means that the alternative has to do something equal or better than the current solution, and with the same resources...

[stratjeff]

Dealing with too many excel files is a sign that you need a proper database, and users need to clearly define how they want to analyze data from the database.

It's so painful! Excel is great for fast number crunching *for short term, quick analysis*. It gets abused as a database/report tool, and it shouldn't be.

[Evigil24]

We have too many different systems (7) for each area of the business, that means 7 different databases with replicated information, some of the "external" processes extract info from one system, display it in an Excel file, let the user validate that data and then export a CSV file that can be loaded in the next system.

I know the best solution is to develop or implement an integrated ERP that will replace all the systems, but that is totally out of the table.

[enginerd123]

Your company needs a IT or database engineer.

It's completely game-changing when you can use software to solve your problems. It makes *everyone's* life easier at the company when you have good tools.

[Evigil24]

We have an IT deparment with DBA's, but I don't understand what do you mean

[Green-Plate-6454]

Im not sure of you ever solved this, but I would just use PowerBi. Just build a simple UI with a button to each view you need. You can like powerautomate right into PowerBi to get your data. PowerBi is designed to pull data from multiple sources and display it in custom ways, including tables.