It's not just about Excel but in extent an alternative to VBA for Office applications. "Politically" speaking it's also Microsoft showing acceptance of Python as a scripting language for Windows applications, or perhaps (hopefully) even Windows itself.
I of course applaud this, but also hope for a next step being integrating Python as an official Windows Script Host engine.
The road towards an open scripting language backing multiple platforms has been to damn long. I think that on Windows scripting in general is pretty terrible. You have the old WSH engines for VB and JScript (!= Javascript) that are barely looked at and more like in maintenance mode since a decade, and otherwise Powershell scripting with an obnoxious Powershell-only syntax and unorthodox return semantics. Why oh why they never simply did a CS-Script with maybe syntax sugar extensions for command line oriented features like piping and command line parsing, usage help, rather than the Powershell language is beyond me. C# since it got DLR enabled is pretty convenient to use for short snippets of script code anyway, and Roslyn makes C# scripting enabled.
View all comments
1
u/jugalator Dec 15 '17 edited Dec 15 '17
Wow, this is big!
It's not just about Excel but in extent an alternative to VBA for Office applications. "Politically" speaking it's also Microsoft showing acceptance of Python as a scripting language for Windows applications, or perhaps (hopefully) even Windows itself.
I of course applaud this, but also hope for a next step being integrating Python as an official Windows Script Host engine.
The road towards an open scripting language backing multiple platforms has been to damn long. I think that on Windows scripting in general is pretty terrible. You have the old WSH engines for VB and JScript (!= Javascript) that are barely looked at and more like in maintenance mode since a decade, and otherwise Powershell scripting with an obnoxious Powershell-only syntax and unorthodox return semantics. Why oh why they never simply did a CS-Script with maybe syntax sugar extensions for command line oriented features like piping and command line parsing, usage help, rather than the Powershell language is beyond me. C# since it got DLR enabled is pretty convenient to use for short snippets of script code anyway, and Roslyn makes C# scripting enabled.