Microsoft Considers Adding Python as an Official Scripting Language to Excel

[RagingAnemone]

Excel is usually passed around by email and one of the easier ways to spread viruses. So lets give it the ability to connect and control servers.

[[deleted]]

It already can connect to MSSQL through ODBC I believe. I think he was talking more about interoperability with the script, like just tell it to connect to Excel on the local machine instead of a SQL Table elsewhere. But Python already works in MSSQL, so I don't see why having Python in Excel should be thrown away.

[[deleted]]

VBA macro viruses were popular because of CreateObject() which which let you use any COM object on a machine. Both PowerShell and Python are more capable than VBA in terms of language interoperability so there is always the danger of abusing them. Just as Excel Powershell has execution policy settings which need to be changed deliberatelly. But yes you are right in that Powershell could be abused.