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

This is just an advertisement for a book. And a terrible advertisement. No sample chapters to evaluate the book.

I am guessing from the TOC that they are using pandas. My team quickly ran into memory spikes when multiple programs using pandas would run. We have since migrated to using ibis with a duckdb backend to smooth out the memory spikes.

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.

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.

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

Many negative comments here stem from readers applying some specific corporate contexts and dismissing the book's use cases. That misses the point. This book isn't an advanced automation manual for 2026. It’s an excellent book for beginners who want to learn how to automate some tedious work.

Yesterday I asked an AI to generate a report as a CSV. But then I wanted it split into multiple sheets, and to add some formulas, so I asked it to create an XLSX, and it did (with Python). I'm imagining Microsoft embedding an AI agent and Python interpreter in their tools... no more need for a software dev, excel expert, or technical book author

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.

"Stop wasting your time on Excel and waste even more coding an Excel parser in Python!"

I prefer DuckDB

What are best practices for using Excel as a front end for python tooling? I’ve got a use case where the business users are maintaining a complex spreadsheet and we need to hook some genuine optimization into it. It’s all fine and good if you assume the people will use the template perfectly, but hahahahahaha

There’s probably some ideal blend of locking regions, in-excel validation, in-python validation, and clean separation of human inputs and machine outputs. Has anyone figured out what that is already?

[dead]

[flagged]

[dead]