如何使用C#和Excel Interop将筛选和复制筛选结果应用到另一个工作表

using Microsoft.Office.Interop.Excel;

Application excelApp = new Application();
Workbook workbook = excelApp.Workbooks.Open("文件路径");

Worksheet sourceSheet = workbook.Sheets["源工作表名称"];
Range sourceRange = sourceSheet.UsedRange;

// 定义筛选条件
string filterCriteria = "筛选条件";

sourceRange.AutoFilter(Field: 1, Criteria1: filterCriteria, Operator: XlAutoFilterOperator.xlFilterValues);

Range filteredRange = sourceRange.SpecialCells(XlCellType.xlCellTypeVisible);

Worksheet targetSheet = workbook.Sheets["目标工作表名称"];
filteredRange.Copy(targetSheet.Cells[1, 1]);

workbook.Close(true);
excelApp.Quit();

using Microsoft.Office.Interop.Excel;

namespace ExcelInteropDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            Application excelApp = new Application();
            Workbook workbook = excelApp.Workbooks.Open("文件路径");

            Worksheet sourceSheet = workbook.Sheets["源工作表名称"];
            Range sourceRange = sourceSheet.UsedRange;

            string filterCriteria = "筛选条件";

            sourceRange.AutoFilter(Field: 1, Criteria1: filterCriteria, Operator: XlAutoFilterOperator.xlFilterValues);

            Range filteredRange = sourceRange.SpecialCells(XlCellType.xlCellTypeVisible);

            Worksheet targetSheet = workbook.Sheets["目标工作表名称"];
            filteredRange.Copy(targetSheet.Cells[1, 1]);

            workbook.Close(true);
            excelApp.Quit();
        }
    }
}