Csharp 在C#中过滤Excel文件

正确过滤范围.这是我为您创建的一个示例.

using Excel = Microsoft.Office.Interop.Excel;

namespace WinFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
           // Hardcoded Excel filename. Change as applicbale
           string excelName = "C:\\Temp\\Book1.xlsx";

           Excel.Application excelApp;
           Excel.Workbook xlWorkBook;
           Excel.Worksheet xlWorkSheet;
            
           excelApp = new Excel.Application{Visible = true};
           xlWorkBook = excelApp.Workbooks.Open(excelName);

           // Change the name of the sheet here
           xlWorkSheet = xlWorkBook.Sheets["Sheet1"];

           // I have hardcoded the filter value. change as applicable
           string SelectedType = "4";

            FilterByCellValue(xlWorkSheet, "V", SelectedType);
        }

        static void FilterByCellValue(Excel.Worksheet worksheet, string column, string cellValue)
        {
            object misValue = System.Reflection.Missing.Value;

            Excel.Range dataRange = worksheet.UsedRange;
            
            // Get the column number where you want to filter
            int ColNumber = worksheet.Range[column + 1].Column;

            // Filter the data range
            dataRange.AutoFilter2(ColNumber, cellValue, Excel.XlAutoFilterOperator.xlFilterValues, misValue, true);
        }
    }
}

Screenshot个

Before个

After个