从C#在Excel中创建数据透视图

using Excel = Microsoft.Office.Interop.Excel;

public void CreatePivotTable(string filePath, string sheetName, string pivotTableName, string dataRange, string pivotTableRange)
{
    // 创建Excel应用程序对象
    Excel.Application excelApp = new Excel.Application();
    excelApp.Visible = true;

    // 打开Excel文件
    Excel.Workbook workbook = excelApp.Workbooks.Open(filePath);
    Excel.Worksheet worksheet = workbook.Sheets[sheetName];

    // 获取数据源范围
    Excel.Range sourceRange = worksheet.Range[dataRange];

    // 创建数据透视表缓存
    Excel.PivotCache pivotCache = workbook.PivotCaches().Create(
        Excel.XlPivotTableSourceType.xlDatabase, sourceRange);

    // 创建数据透视表
    Excel.PivotTable pivotTable = pivotCache.CreatePivotTable(
        worksheet.Range[pivotTableRange], pivotTableName);

    // 设置数据透视表字段
    Excel.PivotField field = (Excel.PivotField)pivotTable.PivotFields("字段名");
    field.Orientation = Excel.XlPivotFieldOrientation.xlRowField;

    // 保存并关闭Excel文件
    workbook.Save();
    workbook.Close();

    // 释放资源
    System.Runtime.InteropServices.Marshal.ReleaseComObject(pivotTable);
    System.Runtime.InteropServices.Marshal.ReleaseComObject(pivotCache);
    System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
    System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
    System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
}