News for hackers. Stuff that matters.
Re:Excel Adds JavaScript and Power BI Support by jimnotgym on Tuesday May 08, 2018 @06:21PM (#17025809)
I'm the kind of person this is directly aimed at, finance background, Excel officionado begging for a better scripting language. I can tell you that I am not interested in js for Excel one bit. Python for Excel however...
Re:Excel Adds JavaScript and Power BI Support by NamTaf on Tuesday May 08, 2018 @09:27PM (#17026789)
I can't agree enough. Python baked in would be a dream come true.
Re:Excel Adds JavaScript and Power BI Support by snthpy on Wednesday May 09, 2018 @05:36AM (#17028523)
+1
Re:Excel Adds JavaScript and Power BI Support by govert on Wednesday May 09, 2018 @07:02PM (#17035056)
Have you given PyXLL a try?
Re:Excel Adds JavaScript and Power BI Support by msaunders77 on Wednesday May 09, 2018 @05:00PM (#17034039)
We did announce (but not yet release) custom Azure Machine Learning functions in Excel. I mention in the blog that since Python runs on Azure ML, you'll be able to run custom Python functions in the cloud, as part of Excel formulas[1].

That announced Azure ML feature is optimized for machine learning models (in terms of the tools/deployment/runtime we've provided), so even though it will work for any Python functions it might not be exactly what you're asking for. Also, depending on your specific use case, you may or may not need client-side execution (Azure ML functions run in the cloud today). I can't share specifics on other unannounced features, but Azure ML functions are only our first foray in this space: we think custom functions running in the cloud are very important for many different use cases in Excel.

Also, note that on the JavaScript side, the language choice isn't something new for Excel or Office: for example, there's a public ecosystem of add-ins that automate Excel via JavaScript today[2]. Custom functions are just the latest way we've enabled for extending Excel as part of an add-in[3].

[1] https://dev.office.com/blogs/azure-machine-learning-javascri... [2] https://appsource.microsoft.com/en-us/marketplace/apps?produ... [3] https://docs.microsoft.com/en-us/office/dev/add-ins/excel/ex...