To apply auto-filtering to a column:
  1. Create a workbook.
  2. Get a worksheet.
  3. Add sample data.
  4. Apply auto-filter.
  5. Auto-fit columns to make the display attractive.
  6. Save the spreadsheet.
The code samples in this article show how to perform these steps using VSTO with either C#, or using Apose.Cells, again with either C#.

VSTO
Excel.Application ExcelApp = Application;

            //Add a Workbook.
            Excel.Workbook objBook = ExcelApp.Workbooks.Add(System.Reflection.Missing.Value);

            //Get the First sheet.
            Excel.Worksheet sheet = (Excel.Worksheet)objBook.Sheets["Sheet1"];

            //Add data into A1 and B1 Cells as headers.
            sheet.Cells[1, 1] = "Product ID";
            sheet.Cells[1, 2] = "Product Name";

            //Add data into details cells.
            sheet.Cells[2, 1] = 1;
            sheet.Cells[3, 1] = 2;
            sheet.Cells[4, 1] = 3;
            sheet.Cells[5, 1] = 4;
            sheet.Cells[2, 2] = "Apples";
            sheet.Cells[3, 2] = "Bananas";
            sheet.Cells[4, 2] = "Grapes";
            sheet.Cells[5, 2] = "Oranges";

            //Enable Auto-filter.           
            sheet.EnableAutoFilter = true;

            //Create the range.
            Excel.Range range = sheet.get_Range("A1", "B5");

            //Auto-filter the range.
            range.AutoFilter("1", "<>", Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlOr, "", true);

            //Auto-fit the second column.
            sheet.get_Range("B1", "B5").EntireColumn.AutoFit();

            //Save the copy of workbook as .xlsx file.
            objBook.SaveCopyAs("vsto_autofilter.xlsx");

Aspose.Cells

 //Instantiate a new Workbook.
            Workbook objBook = new Workbook();

            //Get the First sheet.
            Worksheet sheet = objBook.Worksheets["Sheet1"];

            //Add data into A1 and B1 Cells as headers.
            sheet.Cells[0, 0].PutValue("Product ID");
            sheet.Cells[0, 1].PutValue("Product Name");

            //Add data into details cells.
            sheet.Cells[1, 0].PutValue(1);
            sheet.Cells[2, 0].PutValue(2);
            sheet.Cells[3, 0].PutValue(3);
            sheet.Cells[4, 0].PutValue(4);
            sheet.Cells[1, 1].PutValue("Apples");
            sheet.Cells[2, 1].PutValue("Bananas");
            sheet.Cells[3, 1].PutValue("Grapes");
            sheet.Cells[4, 1].PutValue("Oranges");

            //Auto-filter the range.
            sheet.AutoFilter.Range = "A1:B5";

            //Auto-fit the second column.
            sheet.AutoFitColumn(1, 0, 4);

            //Save the copy of workbook as .xlsx file.
            objBook.Save("asposecells_autofilter.xlsx");



Download

Last edited Jan 1, 2014 at 6:21 AM by asposemarketplace, version 5