Office Script is out
Bruce Mcpherson
Office Script seems to be a kind of Apps Script for Office 365. Only available for Excel at the moment it could be interesting to do a series of comparison articles. To get started Ive added a plugin to my Apps Script cache crusher to use OneDrive as the backend. Watch this space for more updates.
In Apps script library with plugins for multiple backend cache platforms I covered a way to get more into cache and property services, and the bmCrusher library came with built in plugins for Drive, CacheService and PropertyService. Google Cloud Storage platform cache plugin for Apps Script crusher showed how to extend this concept to other back end platforms, using Google Cloud Storage as the service. In this article I’ll show you how to write a plugin to use Microsoft One Drive as the backend
Benefits of using Microsoft OneDrive
Seems pretty crazy, right ? What’s the point when we have Cloud Storage, Property Service, Cache service and even Google Drive. Well, there’s this emerging goodie. Microsoft’s answer to Apps Script – maybe the next installment in the evolution of VBA, Office Script . I’ve written about JavaScript for Office in various posts on this site, and of course plenty about VBA (even a book about it), but Office Script is quite different. I’ll be writing about that quite a bit in coming posts. But to get back to the point – having a universal cache platform to share real time data easily between the Apps Script and Office script world sounds like it would be interesting. So that’s what this is leading to. We can also use much of the same code to read and write content directly to OneDrive for other stuff.
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/onedrive-gas-cache/
Links
bmCrusher
library id: 1nbx8f-kt1rw53qbwn4SO2nKaw9hLYl5OI3xeBgkBC7bpEdWKIPBDkVG0
Github: https://github.com/brucemcpherson/bmCrusher
Scrviz: https://scrviz.web.app/?repo=brucemcpherson/bmCrusher
cGoa
library id: 1v_l4xN3ICa0lAW315NQEzAHPSoNiFdWHsMEwj2qA5t9cgZ5VWci2Qxv2
Github: https://github.com/brucemcpherson/cGoa
Scrviz: https://scrviz.web.app/?repo=brucemcpherson/cGoa
