ExcelScript.DynamicFilterCriteria enum
注解
示例
/**
* 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);
}
字段
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 |
反馈
https://aka.ms/ContentUserFeedback。
即将发布:在整个 2024 年,我们将逐步淘汰作为内容反馈机制的“GitHub 问题”,并将其取代为新的反馈系统。 有关详细信息,请参阅:提交和查看相关反馈