Forum Discussion

terryAnastassiadis's avatar
terryAnastassiadis
Copper Contributor
Mar 13, 2023
Solved

Excel for Web, Office Scripts: TypeScript/ExelScript Event Listener Support

Hi All,   I was taking a look at the https://learn.microsoft.com/en-us/javascript/api/office-scripts/excelscript?view=office-scripts but unless I missed something I have the feeling that Event List...
Excel for web
office 365
Office Scripts
peiyezhu's avatar
peiyezhu
Bronze Contributor
Mar 16, 2023

await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getItem("Sample");
sheet.onSelectionChanged.add(function (event) {
return Excel.run(async (context) => {
console.log("The selected range has changed to: " + event.address);
await context.sync();
});
});
await context.sync();
});

 

 

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/30-events/events-worksheet.yaml
await Excel.run(async (context) => {
    let sheet = context.workbook.worksheets.getItem("Sample");
    sheet.onChanged.add(onChange);
    await context.sync();

    console.log("Added a worksheet-level data-changed event handler.");
});
  • terryAnastassiadis's avatar
    terryAnastassiadis
    Copper Contributor
    Mar 16, 2023
    peiyezhu, thanks again, I took a look at the documentation. It's pretty straightforward, the only logistics I would have to tackle is hosting the manifest file as I would have to clear this first with our IT department.

Resources