Excel.WorksheetSelectionChangedEventArgs interface

Remarques

Ensemble d’API : ExcelApi 1.7

Utilisateur

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

Exemples

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}`);
      });
    }

Propriétés

address

address: string;

type

type: "WorksheetSelectionChanged";

worksheetId

worksheetId: string;