ExcelScript.DynamicFilterCriteria enum
Remarks
Examples
/**
* This script applies a filter to a table that filters it
* to only show rows with dates from the previous month.
*/
function main(workbook: ExcelScript.Workbook) {
// Get the table named "ReportTable".
const table = workbook.getTable("ReportTable");
// Get the column with the header "Date".
const dateColumn = table.getColumnByName("Date");
// Apply a dynamic filter to the column.
// `lastMonth` will only show rows with a date from the previous month.
dateColumn.getFilter().applyDynamicFilter(ExcelScript.DynamicFilterCriteria.lastMonth);
}
Fields
aboveAverage | |
allDatesInPeriodApril | |
allDatesInPeriodAugust | |
allDatesInPeriodDecember | |
allDatesInPeriodFebruary | |
allDatesInPeriodJanuary | |
allDatesInPeriodJuly | |
allDatesInPeriodJune | |
allDatesInPeriodMarch | |
allDatesInPeriodMay | |
allDatesInPeriodNovember | |
allDatesInPeriodOctober | |
allDatesInPeriodQuarter1 | |
allDatesInPeriodQuarter2 | |
allDatesInPeriodQuarter3 | |
allDatesInPeriodQuarter4 | |
allDatesInPeriodSeptember | |
belowAverage | |
lastMonth | |
lastQuarter | |
lastWeek | |
lastYear | |
nextMonth | |
nextQuarter | |
nextWeek | |
nextYear | |
thisMonth | |
thisQuarter | |
thisWeek | |
thisYear | |
today | |
tomorrow | |
unknown | |
yearToDate | |
yesterday |
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 Scripts
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