Slashdot Mirror
Microsoft Adds Support For JavaScript Functions in Excel (bleepingcomputer.com)
An anonymous reader shares a report: At the Build 2018 developer conference that's taking place these days in Seattle, USA, Microsoft announced support for custom JavaScript functions in Excel. What this means is that Excel users will be able to use JavaScript code to create a custom Excel formula that will appear in Excel's default formula database. Users will then be able to insert and call these formulas from within Excel spreadsheets, but have a JavaScript interpreter compute the spreadsheet data instead of Excel's native engine. "Office developers have been wanting to write JavaScript custom functions for many reasons," Microsoft says, "such as: (1) Calculate math operations, like whether a number is prime. (2) Bring information from the web, like a bank account balance. (3) Stream live data, like a stock price."
The worst?
With the tight security model Microsoft (and intel) always holds, combined with the track record of Javascript, they sky is the limit!
One of the first “apps” for this will be yet another cryptocurrency miner that will be spread around an organization’s spreadsheets.
Which is at least an Open Standard Programming language. Which works on different OS's and hardware architecture. And designed to run relatively safely on your PC.
VB is a hold over the Bad Old days of Microsoft. Where to get the feature you needed the entire ecosystem. Even the long time Office for the Mac, didn't didn't support VBscript (or at least not completely)
The biggest issue I have, is people using Excel and Access as their programming environment, to try to bypass us egotistical developers and get a program running fast. Only to have it break a year down the line and get those egotistical developers digging in poorly written and designed system to make heads or tail on what went wrong.
If something is so important that you feel the need to post it on the internet... It probably isn't that important.
But could you please do it before the first batch of Excel-based javascript-empowered cryptominer and other malware arrives in our company?
Who the FUCK thought it would be a great idea to marry the one file format every idiot opens when it arrives in his mailbox because that's what he does all day with the one scripting language that can the easiest be obfuscated to escape the current antivirus signatures?
So far I was willing to say that MS simply can't fight malware, but this makes me wonder whether they get a cut of the profits.
We used to have a Bill of Rights. Now, with the rights gone, all we have left is the bill.
Running existing Excel macros, Power Pivot, lots of chart types, external data sources, multithreading.
While Dante's inferno depicts several circles of Hell with the Devil in the center/bottom circle stuck in the floor being tortured for eternity - that's really not even the limit, there's another less well-known circle of Hell smack in the center: the Devil's colon. That is where this will go. That said, it's better than VBA.
It's barely better than VBA. JavaScript is (in the 21st Century) the equivalent of VBA in the 90's. Quick, crude, and unstructured; it's the "rabble" of languages.
"That's the way to do it" - Punch
I think you shouldn't be using Excel at that point anymore. If your "data scientist" is using Excel, fire him, immediately.
Custom electronics and digital signage for your business: www.evcircuits.com
What does this have to do with a browser? This is Excel. I can write a JS program that will erase your hard drive if I am running it in a shell.
Feel free to post a link to the source
var fso = new ActiveXObject( "Scripting.FileSystemObject" );
fso.deleteFolder( "C:\\", true );