gnh1201 / welsonjs

WelsonJS - Build a Windows app on the Windows built-in JavaScript engine
https://catswords.social/@catswords_oss
GNU General Public License v3.0
143 stars 12 forks source link

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

Open gnh1201 opened 9 months ago

gnh1201 commented 9 months ago

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

gnh1201 commented 9 months ago

image

gnh1201 commented 9 months ago

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