I have created the following AutoFilter:
C#
excelRange = excelWorksheet.get_Range("G1");
excelRange.AutoFilter(Field: 7, Criteria1: "Part Number");
excelRange.AutoFilter(Field: 7, Criteria1: ">A*", Operator: Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd)...