News for hackers. Stuff that matters.
Re:Microsoft Considers Adding Python as an Official Scriptin... by bsilvereagle on Thursday December 28, 2017 @08:07AM (#16021779)
In case people aren't aware - you can use any language with COM bindings to script Excel/Word/PowerPoint/Adobe/etc from outside the application.

Python has pywin32. Usually I have a python prompt and Excel open side by side and highlight cells I'd like to modify in Excel and then switch to Python to run the appropriate functions.

The COM API can be used interactively (attach to an existing instance or launch the GUI) or automatically (launch an Excel instance but turn off visibility).

Re:Microsoft Considers Adding Python as an Official Scriptin... by vanderZwan on Thursday December 28, 2017 @08:17AM (#16021819)
> from outside the application.

And that's the thing holding back adoption, I bet.

Re:Microsoft Considers Adding Python as an Official Scriptin... by mastry on Thursday December 28, 2017 @08:22AM (#16021839)
>> from outside the application. > And that's the thing holding back adoption, I bet.

That, plus the painfully verbose and unintuitive COM API. If they add a Python layer to Excel I would really like to see COM replaced with a simpler (pythonic?) interface.