Aspose.Cells.GridWeb.Examples.CSharp.Cells.SetAutoFilter.InitGridWeb C# (CSharp) Method

        private void InitGridWeb()
        {
            GridWeb1.WorkSheets.Clear();

            // Gets the web application's path.
            string path = (this.Master as Site).GetDataDir();

            string fileName = path + "\\Cells\\Products.xlsx";

            // Imports from an excel file.
            GridWeb1.ImportExcelFile(fileName);
            GridWeb1.ActiveCell = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex].Cells["A1"];

            // ExStart:SetAutoFilter
            // Access active worksheet
            var sheet = GridWeb1.WorkSheets[this.GridWeb1.ActiveSheetIndex];

            // Enable GridWeb's auto-filter.
            sheet.AddAutoFilter(0, 0, sheet.Cells.MaxDataColumn);
            sheet.RefreshFilter();
            // ExEnd:SetAutoFilter
        }
    }