this will cause so much pain for devs around the world. JS in Excel

link
https://theverge.com/2021/11/...

🤮

Better than VBA

Say what you want about MS, they realised where they were going wrong and started fixing their shit really the right way.

Beating Google in digitals products and competing Apple in hardware space.

Competing with Sheets here.

Time to place some bets on MS again, eh?

Oh no.

@RememberMe To be fair one can use any language with COM support (e.g. VBA, JScript, Powershell, C(++/#), Go ...) to automate Excel but only from the outside.

Better than vb

It was only a matter of time.
They already allowed it for office online.

Now we wait for Doom written in excel.

But excel has had a JS API since office 2016 according to

https://docs.microsoft.com/en-us/...

"Introduced with Office 2016, the Excel JavaScript API provides strongly-typed objects that you can use to access worksheets, ranges, tables, charts, and more."

@heyheni @electrineer @Ranchonyx Can you provide some reasons about your comments... if you can

@dontbeevil js and excel

@dontbeevil it's more javascript. We already have enough of that cardinal sin.

When you are just unable to learn anything from past macro-based malware epidemics...

It isn't, that they aren't trying - they literally can't improve on security no matter what.
The basic concept of attack surface is something so alien to them - they even have a kernel-based antivirus parsing dozens of exotic archive formats running in their OS by default.

So yeah, next malware pandemic will be JS-infested Excel sheets. Not that it matters whether it is JS or VBA anyway...

@dontbeevil companies do too much with Excel, when it really should be a standalone application.

My JS is dog shit analogy just keeps holding true.

Excel is the fridge.

Is this why I haven't been able to access any of my worksheets using office 365? Fucking microsoft.

JavaScript was a mistake

@electrineer @Ranchonyx @Oktokolo @heyheni oh in general I agree and understand your points... But in the end it's bit better/easier to use a "standard" language as js compared to vba. Of course you don't have to overdue everything in excel.

P. S.
In general I hate js

@dontbeevil
My point has nothing to do with the choice of language.

Way better than VBA.

@dontbeevil ah well, in the context if VBA I agree.

excel still uses internet explorer internally, rigth? no more patches for that 😏

They day has come, I can finally get drunk enough to forget all about VBA! 🍻👏🎉

@Desinika noice! 😃

We should use ecma script instead in Excel. Much better language.

even if you'd use lisp that wouldn't stop malware creation

Actually, no, I'm looking forward to this now.

I don't wanna touch VBA with a 10 foot pole

...and JS just keeps on infecting and ruining everything... :(

@Midnight-shcode in general I agree, but for small scripts stuff like this I think a "standard" language like JS is great, instead of a proprietary one. JS ruins desktop web/electron apps, instead of native ones

@dontbeevil but "standard" is just a matter of proliferation, in this context.

and js is prolific by mistake, accident, for all the wrong reasons and no good one.

and everyone just keeps conceding to it.

it's like Munich Diktat 2.0

and the later everyone realizes, the worse the war will be.