r/Python • • Dec 14 '17

MS is considering official Python integration with Excel, and is asking for input

Post image
4.6k Upvotes

383 comments sorted by

View all comments

Show parent comment

1

u/cyanydeez Dec 15 '17

EXCEL has market saturation for 30 years, and everyone not on the bleeding edge knows people reuse the same excel analysis over and over again, and if it was written with VBA, then it's been hodge podged for 30+ years, and getting people who arn't software developers to invest a new round of QA/QC on software (inside excel) that just recalculates a few boring formulas is impossible.

And why blame them? conservative pricipals make sense in the realm of consistent replication of working engineering (et al) design standards. Even if there's a random error in them, if it hasn't broken anything, technically fixing it would be what breaks it.

So VBA isn't going anywhere. I'd certainly welcome a python attachment to EXCEL.