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 1 year 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

image

gnh1201 avatar Nov 27 '23 09:11 gnh1201

Changed the excel.setValueByPosition(x, y, c) to excel.getCellByPosition(x, y).setValue(c) b87aad537ac594bab8ce2215362a203d8eb4d5fc

gnh1201 avatar Nov 27 '23 16:11 gnh1201