3 ms·
I've been using JS in Google Sheets, so this is a welcome addition. Honestly, assuming you're already a software engineer, JS functions basically enable you to
by sp527 8y ago
I've been using JS in Google Sheets, so this is a welcome addition. Honestly, assuming you're already a software engineer, JS functions basically enable you to be a wizard in Excel. Haven't even been at it that long and I've already managed to impress some of my friends in finance with what I was doing in Sheets.
This is a huge game-changer and it also introduces the opportunity for enterprising (pun?) software developers to be a lot more valuable to a business by moving core business logic out of VBA into git-managed JS and making it versioned, highly reusable, etc. Going a bit further, I see an avenue to offload heavy compute to servers and create a usable link between Excel and e.g. Cassandra/Spark/HDFS.
You have to appreciate just how fundamental Excel is to businesses to see the size of the opportunity Microsoft just gifted to developers.