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);
filtering but not giving correct counts of filtered row
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);
}