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.
[ Parent
| on HN ]
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.