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

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.