Hacker News new | ask | show | jobs
by mcdonje 1239 days ago
They might have some involvement in python libraries or tooling to interact with excel files from python apps, but the default programming support within excel is still VBA. They did add a javascript API, but getting that up and running is a job geared more for a dev than a data analyst.

What I think they should do is not just make a python API, but replace VBA with it, and expose it to end users where VBA is currently exposed. Python should be the language of macros and user defined functions.
2 comments
raarts 1237 days ago
I tried to find info on how to set that up a while ago, but found nothing. The Microsoft pages gave me the impression it only works for the web version. Akso I'm on MacOS - couldn't find any mention of that either.
link
kevin_thibedeau 1239 days ago
They should dust off Windows Scripting Host and use that as the nexus for Office app scripting.
link