welsonjs icon indicating copy to clipboard operation
welsonjs copied to clipboard

[lib/msoffice] WelsonJS - Microsoft Office (e.g. Excel) integration

Open gnh1201 opened this issue 9 months ago • 2 comments

Summary

Integrating WelsonJS with Microsoft Office (e.g., Excel). Enables the creation of Office macros using the ECMAScript syntax of WelsonJS.

The means by which this is made possible currently are as follows:

  1. Implementation of a bridge API using WelsonJS.Toolkit COM interface.
  2. ExcelDNA
  3. Securing control by invoking Microsoft Office through WelsonJS. (e.g. Excel.Application)
  4. Use lib/pipe-ipc
  5. Make a simple VM(Virtual Machine) in VBA runtime

Related links

  • https://stackoverflow.com/questions/20171885/excel-macros-with-javascript
  • https://stackoverflow.com/questions/70550794/is-it-possible-to-use-javascript-to-automate-excel-without-hosting-an-add-in
  • https://github.com/joinr/sporklisp (LISP interpreter on VBA)

gnh1201 avatar Nov 24 '23 03:11 gnh1201