在活动的Excel电子表格上应用空筛选器- C#

using Excel = Microsoft.Office.Interop.Excel;

public void ApplyBlankFilter()
{
    // 创建Excel应用程序对象
    Excel.Application excelApp = new Excel.Application();

    // 打开Excel文件
    Excel.Workbook workbook = excelApp.Workbooks.Open("path_to_your_excel_file");

    // 获取活动工作表
    Excel.Worksheet worksheet = workbook.ActiveSheet;

    // 获取数据范围
    Excel.Range dataRange = worksheet.UsedRange;

    // 应用空筛选器
    dataRange.AutoFilter(1, Type.Missing, Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true);

    // 关闭Excel文件并释放资源
    workbook.Close();
    excelApp.Quit();
    System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
    System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
    System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
}