Excel Adds JavaScript and Power BI Support

#1

Post by pjmlp » Tue, May 08, 2018, 8:17 AM UTC

Excel Adds JavaScript and Power BI Support
dev.office.com

Re: Excel Adds JavaScript and Power BI Support

#2

Post by Ftuuky » Tue, May 08, 2018, 1:01 PM UTC

But no Python support as they promised. So sad.

Re: Excel Adds JavaScript and Power BI Support

#3

Post by sevensor » Tue, May 08, 2018, 1:16 PM UTC

> Office developers have been wanting to write JavaScript custom functions for many reasons, such as:

> • Calculate math operations, like whether a number is prime.

It saddens me that this is a thing we want Javascript for.

So anyway, now we have XLL, COM, VBA, and Javascript. All of them different but overlapping ways to extend what Excel can do. Am I missing any?

Re: Excel Adds JavaScript and Power BI Support

#4

Post by realslimjd » Tue, May 08, 2018, 1:30 PM UTC

Ftuuky wrote: post #2

But no Python support as they promised. So sad.

They never promised Python support.

Re: Excel Adds JavaScript and Power BI Support

#5

Post by zimablue » Tue, May 08, 2018, 1:31 PM UTC

Ftuuky wrote: post #2

But no Python support as they promised. So sad.

If that's true, this stuff just changed the world more than half of the political issues that people march on streets about. The brightest people in office jobs around the world that aren't well integrated with developer teams (almost all of them) just got pushed to learn javascript, puke.

Re: Excel Adds JavaScript and Power BI Support

#6

Post by Ftuuky » Tue, May 08, 2018, 1:32 PM UTC

realslimjd wrote: post #4

Ftuuky wrote: post #2

But no Python support as they promised. So sad.

They never promised Python support.

I think they were considering it, they even sent out a survey.

https://news.ycombinator.com/item?id=15927132

Re: Excel Adds JavaScript and Power BI Support

#7

Post by Maybestring » Tue, May 08, 2018, 1:33 PM UTC

sevensor wrote: post #3

> Office developers have been wanting to write JavaScript custom functions for many reasons, such as: > • Calculate math operations, like whether a number is prime. It saddens me that this is a thing we want Javascript for. So anyway, now we have XLL, COM, VBA, and Javascript. All of them different but overlapping ways to extend what Excel can do. Am I missing any?

Power Query M

Re: Excel Adds JavaScript and Power BI Support

#8

Post by riskneutral » Tue, May 08, 2018, 1:33 PM UTC

VBA wasn’t bad enough, now millions of analysts will have to contend with spreadsheet spaghetti and JavaScript.

Re: Excel Adds JavaScript and Power BI Support

#9

Post by riskneutral » Tue, May 08, 2018, 1:34 PM UTC

sevensor wrote: post #3

> Office developers have been wanting to write JavaScript custom functions for many reasons, such as: > • Calculate math operations, like whether a number is prime. It saddens me that this is a thing we want Javascript for. So anyway, now we have XLL, COM, VBA, and Javascript. All of them different but overlapping ways to extend what Excel can do. Am I missing any?

RTDServer

Re: Excel Adds JavaScript and Power BI Support

#10

Post by cremp » Tue, May 08, 2018, 1:37 PM UTC

I can't wait to see how this is exploited in a few hours...