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.
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).