Excel.WorksheetSelectionChangedEventArgs interface

Hinweise

API-Satz: ExcelApi 1.7

Verwendet von

• Excel.Worksheet: onSelectionChanged
• Excel.WorksheetCollection: onSelectionChanged

Beispiele

async function registerEventHandlers() {
      await Excel.run(async (context) => {
        // Add a selection changed event handler for the worksheet.
        let sheet = context.workbook.worksheets.getItem("Sample");
        sheet.onSelectionChanged.add(onWorksheetSelectionChange);

        // Add a selection changed event handler for the worksheet collection.
        context.workbook.worksheets.onSelectionChanged.add(onWorksheetCollectionSelectionChange);

        await context.sync();
      });
    }

    async function onWorksheetSelectionChange(args: Excel.WorksheetSelectionChangedEventArgs) {
      await Excel.run(async (context) => {
        console.log(`Worksheet event: The address of new selection is: ${args.address}`);
      });
    }

    async function onWorksheetCollectionSelectionChange(args: Excel.WorksheetSelectionChangedEventArgs) {
      await Excel.run(async (context) => {
        console.log(`WorksheetCollection event: The address of new selection is: ${args.address}`);
      });
    }

Eigenschaften

address

address: string;

type

type: "WorksheetSelectionChanged";

worksheetId

worksheetId: string;