I have created the following AutoFilter:
C#
This reduced the rows down to a number let's say 935. How do I loop through the 935 rows produced by the AutoFilter?
C#
Code:
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);
excelRange.AutoFilter(Field: 4, Criteria1: "<2023-01-01", Operator: Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd);
This reduced the rows down to a number let's say 935. How do I loop through the 935 rows produced by the AutoFilter?