r/programming • • May 08 '18

Excel adds JavaScript support

https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel
2.4k Upvotes

585 comments sorted by

View all comments

Show parent comments

0

u/[deleted] May 08 '18

[deleted]

3

u/cediddi May 08 '18

Js is surely well known, but is it up for the task? Being well known is surely important but that alone can't be the main reason.

0

u/[deleted] May 08 '18

[deleted]

6

u/cediddi May 08 '18

Because being well known doesn't mean js has right features for this kind of task. Js is a event loop based language and it excels at networking tasks. But for calculations or advanced stuff, you depend on 3.rd party libraries. Python has a great selection of standard libraries, would fit better, except it wouldn't fit on a browser environment. Scala or kotlin is also have good stdlib, sensible defaults and work well on browser environment. It would be great if you wouldn't transpile them to js...

0

u/[deleted] May 08 '18

[deleted]

1

u/cediddi May 09 '18

I'd say standard library of python is good. math, cmath, decimal, fractions, random, statistics, itertools, functools and operator would be very useful for excel. Apart from that, numpy, pandas and scipy are golden. MS or 3rd. party libs can provide exact functionality too, but does JS really have strong foot on such workloads?

3

u/[deleted] May 08 '18

Because this shitty retarded statement-based language have no features whatsoever to support the native Excel data types. Meaning unavoidable implicit bullshit conversions.

1

u/[deleted] May 08 '18

I find it hard to believe that the population scripting Excel and the population using JS is a huge overlap. Something like python or R seems like a better fit.

-2

u/[deleted] May 08 '18

And how is this even an argument? Fucking popularity should never be an argument.

0

u/[deleted] May 08 '18

[deleted]

-1

u/[deleted] May 08 '18 edited May 08 '18

No it should not. Is javascript a popular language for spreadsheets? No. Then why the fuck bringing this irrelevant "popularity" into this topic at all?

Also, how the fuck ease of implementation is relevant? It is trivial to implement pretty much any language anyway.

1

u/chucker23n May 08 '18

Is javascript a popular language for spreadsheets?

It is now. Why would look Microsoft look backwards on that?