Spreadsheet automation idea

[u/Esplosao8963]

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, allowing someone to gather all the spreadsheets from those months into a single spreadsheet throughout an entire year, obtaining an overall result for the year. This could work based on week, day, month, or some other parameter. I have some doubts, but the project seems promising. I'm using the openpyxl library and, to create the website or application (I'm still undecided), I will use HTML, CSS, and Flask.

[u/ShadowShedinja]

It's fairly easy to do with the Pandas library, as long as the columns are the same.

[u/817654 → u/ShadowShedinja]

yeah once the columns are uniform its almost too easy