Re:Ditching Excel for Python in a legacy industry
by RobinL on Thursday December 31, 2020 @01:32PM
(#25595506)
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.
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.