Filtering ListObjects with Excel AutoFilter function using Spreadsheet

 

The following C# code will filter 'Apple' and 'Orange' using an Array

private void ExcelFilterExample()
        {
            String[] FilterList = {"Apple","Orange"};
            Excel.Workbook oWB = Globals.ThisAddIn.Application.Workbooks.Open(@"C:\Users\comp\Documents\FreshFruitsnVegetables.xls");
            Excel.Worksheet oWS = oWB.Worksheets[1];
            oWS.ListObjects.AddEx (Excel.XlListObjectSourceType.xlSrcRange, oWS.UsedRange, System.Type.Missing  ,Excel.XlYesNoGuess.xlYes).Name = "FruitList"; 
            oWS.ListObjects["FruitList"].Range.AutoFilter(2, FilterList, Excel.XlAutoFilterOperator.xlFilterValues   );
        }