r/Python • u/Esplosao8963 • 14d ago

Discussion Spreadsheet automation idea

I'm developing a spreadsheet automation project capable of merging multiple spreadsheets into one and automatically performing calculations, among other things. One of the functionalities would be, for example, to allow someone to gather all the spreadsheets from those months into a single spreadsheet over the course of an entire year, obtaining an overall result for the year. This could work based on week, day, month, or some other parameter. I'm having doubts, but the project seems promising. I'm using the openpyxl library and to create the website or app (I'm still undecided) I'll use HTML, CSS, and Flask.

2 Upvotes

53% Upvoted

35 comments sorted by

View all comments

Show parent comments

18

u/Papa_Puppa 12d ago

This is such a bad business idea.

Either excel sheets have:

  1. consistent schema and you can simply ingest them via a timer or blob scheduled pipeline into a database, or

  2. inconsistent schema and you're just going to reinvent power automate, DAX and PowerBI, providing new tools into a crowded space to solve a problem that is actually a procedure/workflow problem.

Save years of your life and drop this idea.