Excel.FilterOn enum

Remarks

[ API set: ExcelApi 1.2 ]

Examples

// This function adds a custom AutoFilter to the active worksheet 
// and applies the filter to a column of the used range.
await Excel.run(async (context) => {
    // Retrieve the active worksheet and the used range on that worksheet.
    const sheet = context.workbook.worksheets.getActiveWorksheet();
    const farmData = sheet.getUsedRange();

    // Add a filter that will only show the rows with values that end with the letter "e" in column 1.
    sheet.autoFilter.apply(farmData, 1, {
        criterion1: "=*e",
        filterOn: Excel.FilterOn.custom
    });

    await context.sync();
});

Fields