Enum DynamicFilterType

DynamicFilterType enumeration

Dynamic filter type.

public enum DynamicFilterType

Values

NameValueDescription
AboveAverage0Shows values that are above average.
BelowAverage1Shows values that are below average.
LastMonth2Shows last month’s dates.
LastQuarter3Shows last quarter’s dates.
LastWeek4Shows last week’s dates.
LastYear5Shows last year’s dates.
January6Shows the dates that are in January, regardless of year.
October7Shows the dates that are in October, regardless of year.
November8Shows the dates that are in November, regardless of year.
December9Shows the dates that are in December, regardless of year.
February10Shows the dates that are in February, regardless of year.
March11Shows the dates that are in March, regardless of year.
April12Shows the dates that are in April, regardless of year.
May13Shows the dates that are in May, regardless of year.
June14Shows the dates that are in June, regardless of year.
July15Shows the dates that are in July, regardless of year.
August16Shows the dates that are in August, regardless of year.
September17Shows the dates that are in September, regardless of year.
NextMonth18Shows next month’s dates.
NextQuarter19Shows next quarter’s dates.
NextWeek20Shows next week’s dates.
NextYear21Shows next year’s dates.
None22None.
Quarter123Shows the dates that are in the 1st quarter, regardless of year.
Quarter224Shows the dates that are in the 2nd quarter, regardless of year.
Quarter325Shows the dates that are in the 3rd quarter, regardless of year.
Quarter426Shows the dates that are in the 4th quarter, regardless of year.
ThisMonth27Shows this month’s dates.
ThisQuarter28Shows this quarter’s dates.
ThisWeek29Shows this week’s dates.
ThisYear30Shows this year’s dates.
Today31Shows today’s dates.
Tomorrow32Shows tomorrow’s dates.
YearToDate33Shows the dates between the beginning of the year and today, inclusive.
Yesterday34Shows yesterday’s dates.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;

    public class DynamicFilterTypeDemo
    {
        public static void DynamicFilterTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();

            // Add a new worksheet to the workbook
            Worksheet worksheet = workbook.Worksheets[0];

            // Add sample data to the worksheet
            worksheet.Cells["A1"].PutValue("Date");
            worksheet.Cells["A2"].PutValue(new DateTime(2023, 1, 1));
            worksheet.Cells["A3"].PutValue(new DateTime(2023, 2, 1));
            worksheet.Cells["A4"].PutValue(new DateTime(2023, 3, 1));
            worksheet.Cells["A5"].PutValue(new DateTime(2023, 4, 1));
            worksheet.Cells["A6"].PutValue(new DateTime(2023, 5, 1));

            worksheet.Cells["B1"].PutValue("Value");
            worksheet.Cells["B2"].PutValue(10);
            worksheet.Cells["B3"].PutValue(20);
            worksheet.Cells["B4"].PutValue(30);
            worksheet.Cells["B5"].PutValue(40);
            worksheet.Cells["B6"].PutValue(50);

            // Apply auto filter to the worksheet
            worksheet.AutoFilter.SetRange(0, 0, 5);

            // Apply a dynamic filter to show only dates in March
            worksheet.AutoFilter.DynamicFilter(0, DynamicFilterType.March);

            // Save the workbook
            workbook.Save("DynamicFilterTypeExample.xlsx");
            workbook.Save("DynamicFilterTypeExample.pdf");

            // Output the results
            Console.WriteLine("Dynamic filter applied to show only dates in March.");
        }
    }
}

See Also