How to get correct Row count of filtered excel in c# interoperobility

Question

Issue is my code always return one row instead of 13. I need to create a text file based on the filtered rows.But i am not getting the correct count and filtered rows.I will add and remove other clms .but row has issue.I need to get rows having colum value 01

xlRange.AutoFilter(17, "01", Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlFilterValues, Type.Missing, true);

This line filtering but not giving correct counts of filtered row

what i have tried:

public static void ExportToTextFile(Excel._Worksheet xlWorksheet, Excel.Workbook xlWorkbook, Excel.Application xlApp, string wbname)

        {

            //creating .txt file with new coloumns



            Excel._Worksheet xlWorksheetNew = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkbook.Sheets[1]; // excel sheet

            xlWorksheet.Copy(xlWorksheetNew); //copying from another xl

            Excel.Range excelRange = xlWorksheetNew.UsedRange;



            xlWorksheetNew.Cells[1, 18] = "FLAG";





            Microsoft.Office.Interop.Excel.Range xlRange = xlWorksheetNew.UsedRange;



          xlRange.AutoFilter(17,"01",Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlFilterValues, Type.Missing, true);


            int Columns = xlWorksheetNew.UsedRange.Columns.Count;

            int Rows = filteredRange.Rows.Count; //NOT GIVING CORRECT COUNT


            ((Excel.Range)xlWorksheetNew.Columns["P:Q"]).Delete();

            ((Excel.Range)xlWorksheetNew.Columns["C"]).Delete();

            ((Excel.Range)xlWorksheetNew.Columns["A:B"]).Delete();




            int AfterdeletColumns = xlWorksheetNew.UsedRange.Columns.Count;

            int afterdeletRows = filteredRange.Rows.Count;



             xlWorksheetNew.Visible = Excel.XlSheetVisibility.xlSheetHidden;


            ExportToTextFile(Rows, Columns, xlWorksheetNew);

        }

Answer 1

Take a look at the suggested solutions in https://stackoverflow.com/questions/17285897/row-count-on-the-filtered-data