Introducing Visual Scheme for Applications: Modernizing Office Solutions on the CLR
In this lightning talk, we demonstrate Visual Scheme for Applications(tm) (VSA) as both an Excel formula language and a general-purpose scripting feature of Microsoft 365, comparing VSA’s first-class lambda support to the new LET and LAMBDA functions in Excel’s built-in formula expression language, and highlighting its extrinsic value as an interoperability aid for Office solutions at multiple levels. VSA breaks out of Excel’s deterministic calculation model with integrated logic programming, making direct database access transparent such that storing data “in Excel” is no longer an antipattern but architecturally supported with minimal conceptual fuss for the end-user. For example, the ability to use a lambda defined in Scheme both as a spreadsheet function and as an extension of ANSI SQL using the “custom function” API of the popular SQLite engine, with full access to the .NET runtime under the hood in both contexts, makes it possible to do many things in Excel that were previously unimaginable. Finally, we show a preview of Clojure and Scheme “tag teaming” the task of modernizing legacy Office solutions to the latest cross-platform microservices patterns and practices.
Fri 16 SepDisplayed time zone: Belgrade, Bratislava, Budapest, Ljubljana, Prague change
14:00 - 15:30
|Introducing Visual Scheme for Applications: Modernizing Office Solutions on the CLRVirtual|
Bob Calco Apex Data Solutions, LLC
|An FFI between Gambit Scheme and CPythonVirtual|
|R7RS Large Status ReportVirtual|