Re:Excel team considering Python as scripting language: aski...
by odonnellryan on Thursday December 14, 2017 @04:30PM
(#15927255)
So what's the strategy here re: security? I assume it'd be a fairly stripped-down version of Python ... or will you just design the UI to say "you probably shouldn't execute files from people you don't know" etc?
[ Parent
| on HN ]
Re:Excel team considering Python as scripting language: aski...
by esmi on Thursday December 14, 2017 @04:40PM
(#15927355)
From a security point of view how is embedding python different from embedding Visual Basic? This is not my area of expertise so I’m genuinely curious.
Re:Excel team considering Python as scripting language: aski...
by Groxx on Thursday December 14, 2017 @04:57PM
(#15927519)
Potentially different. .NET allows signed binaries / libs / a fully signed execution context, Python has nothing equivalent AFAIK.
Re:Excel team considering Python as scripting language: aski...
by auxym on Thursday December 14, 2017 @05:25PM
(#15927773)
Excel VBA is not .Net though. It's plain old VB code in text files inside the .xlsx, and you just have to trust it (or not).
Re:Excel team considering Python as scripting language: aski...
by Groxx on Thursday December 14, 2017 @05:56PM
(#15928068)
Aaah. Then probably about the same, yea :) Maybe less of a nightmare around dependencies than the pip world...?
Re:Excel team considering Python as scripting language: aski...
by davb on Thursday December 14, 2017 @04:39PM
(#15927346)
I’d rather full fat Python but heavily sandboxed with some form of firewall. “Do you want to allow 2018_Stock_Report_Q1.xlsp to connect to api.erp.corp.mycompany.com?”. Codesigning with my something under my corp CA, manage permissions via Group Policy and let users, on a per-endpoint or per-permission basis, authorise things like filesystem access, network connections, etc.
Re:Excel team considering Python as scripting language: aski...
by smortaz on Thursday December 14, 2017 @04:38PM
(#15927341)
Challenges exist & will have to be looked at for sure. Incidentally, one of the guys on our team just a gave talk on his PEP for "Secure" Python:
https://www.python.org/dev/peps/pep-0551/
There's a YT talk as well.