Excel.WorksheetCalculatedEventArgs interface

Comentarios

Conjunto de API: ExcelApi 1.8

Usada por

• Excel.Worksheet: onCalculated
• Excel.WorksheetCollection: onCalculated

Ejemplos

async function registerOnCalculatedHandler() {
    await Excel.run(async (context) => {
        let sheet = context.workbook.worksheets.getItem("Sample");
        sheet.onCalculated.add(onCalculated);
        await context.sync();
    });
}

async function onCalculated(event: Excel.WorksheetCalculatedEventArgs) {
    await Excel.run(async (context) => {
        // `event.address` returns the address of the range that completed calculation.
        // If multiple ranges completed calculation, the string is a comma-separated list of those range addresses.
        console.log(`The Range ${event.address} has recalculated.`);
    });
}

Propiedades

type

type: "WorksheetCalculated";

worksheetId

worksheetId: string;