Automate Excel with Python: From manual grind to one-click workflow

in a world of ai agents, python is just an implementation detail that you don't need to know, between you and your data/business task

These sort of things always seem to assume a fairly relaxed software environment.

In practice I’ve found the big corporates try hard to keep their excel files with financial data and their Python environments with pip & all those associated risks far apart. That’s if pip works at all & isn’t caught by a firewall

Looking at the content, if you are familiar at all with Python and basic programming, this provides very little new. I sometimes have to stuff massive Excel-abominations with 50k+ rows and rip data I need out of them with Pandas, but it only requires reading Pandas documentation (which is very good) a bit.

But perhaps this might be good if you know no programming and want to make your life easier.

[dead]

Been working on a dashboard that takes in a bunch of different public data sources in different formats and pandas has truly been a godsend for this.

I've got csv, txt, xlsx in all different shapes and sizes and with just a few settings I can go through them quite easily and very fast as well.

I prefer DuckDB

Terrible title. Nothing to do with automating excel. From what I can tell it seems to be about ingesting spreadsheets into panda (and incredibly narrow use of Excel) and working outside of Excel.