I'm messing around w/ Office Dialog for Add-Ins in JS. I've got it so far where I can open a dialog, capture input to console, run a function from a button and close the dialog box, but I can't seem to get my function to interact with Excel. It's lost context I beleive, I tried using this and I get no errors, but it doesn't work --> var context = new Excel.RequestContext() . Here is my open function and my main function and the end function. main.js export async function helloworld(event) { try { await Excel.run(async (context) => { //Start Func console.log("BEFORE OPEN UI"); openDialog("/yo/dist/dialog.html", 30, 20); console.log("AFTER OPEN UI"); await context.sync() .then(function () { console.log("AFTER SYNC UI"); var ws = context.workbook.worksheets.getActiveWorksheet();
A site where you can share knowledge