Enterprise Architect modelling tool from Sparx Systems (www.sparxsystems.com) integrates SpiderMonkey Javascript engine 1.8.
This is useful to create JS scripts in this tool and make use of its Interop API.
I managed to create a simple Logging class to output info and debug message.
I’m struggling in getting Excel Application to work ; I need to open Excel to read or write information. I can’t find any information from the MDN docs (except from https://developer.mozilla.org/en-US/docs/Archive/Web/JavaScript/Microsoft_Extensions/ActiveXObject which doesn’t provide working samples).
The following works as I can see a new Ms.Excel process in the task manager:
var ExcelSheet = new COMObject('Excel.Sheet',true);
But as soon as I try to create a workbook or worksheet object, it doesn’t work.
Is there any working example or reference I can look at to fix this?