I was more thinking about migrating away from Excel fully rather than interfacing with Excel from Python. I agree that to interact with Excel programmatically

I was more thinking about migrating away from Excel fully rather than interfacing with Excel from Python. I agree that to interact with Excel programmatically VBA is a better choice (and no doubt C#/VB.NET as well, but I have no direct experience). For what it's worth, for interacting with Excel and Office more generally, I've always though VBA is extremely well designed.