Excel.FilterOn enum
Remarks
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
bottomItems = "BottomItems" | |
bottomPercent = "BottomPercent" | |
cellColor = "CellColor" | |
custom = "Custom" | |
dynamic = "Dynamic" | |
fontColor = "FontColor" | |
icon = "Icon" | |
topItems = "TopItems" | |
topPercent = "TopPercent" | |
values = "Values" |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for