News for hackers. Stuff that matters.
Re:Ditching Excel for Python in a legacy industry by cutler on Thursday December 31, 2020 @12:45PM (#25594950)
Yes, I was wondering why Python was the automatic choice considering C#.Net has typesafe native APIs for Excel on Windows.
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.