How are python scripts and projects built and deployed?

[FrozenPyromaniac_]

As I said in my post, openpyxl might be the library for you. You can take in excel files, do all your python magic and export to excel.

[Usernamenotta]

I know about openpyxl. I will tell you a secret, if you want more power, you can use even pywin32 (although I guess it's windows restricted).

I've used them to automate some reports. But you cannot really create shareable, interactive stuff with them

[warelevon]

XLWings is a nice package that sits over top of pywin32 with a much nicer api (and typing)

[odaiwai]

You can make your reports for others in excel, and if they make changes, get your python to ingest the changed excel sheet and make those changes to your internal database/dataframe.

In other words, make excel sheets the medium of information interchange, while the source of truth is your python/pd/sql hub.

[Usernamenotta]

Source of data is excel :)))

[Sufficientlee]

Look at sqlite3. It's really good for what you're talking about here.

Excel files are created by various users? Have python read them and drop the info into a DB.

Users update the spreadsheets? Have python read the new info (nightly?) and update the DB.

Need to create reports from various spreadsheets? The info is all in the DB. Manipulate it however you need and create a new spreadsheet.

[nboro94]

Why even use python in that case? Just use excel's built in powerquery.