closedxml透视表报表筛选默认值

using ClosedXML.Excel;

// 创建一个新的Excel工作簿
var workbook = new XLWorkbook();

// 添加一个工作表
var worksheet = workbook.Worksheets.Add("Sheet1");

// 添加示例数据
worksheet.Cell("A1").Value = "Category";
worksheet.Cell("B1").Value = "Amount";
worksheet.Cell("A2").Value = "Category 1";
worksheet.Cell("B2").Value = 100;
worksheet.Cell("A3").Value = "Category 2";
worksheet.Cell("B3").Value = 200;
worksheet.Cell("A4").Value = "Category 1";
worksheet.Cell("B4").Value = 300;

// 创建透视表
var pivotTable = worksheet.PivotTables.Add("PivotTable", worksheet.Cell("D1"), worksheet.Range("A1:B4"));

// 设置透视表的行标签和值字段
pivotTable.RowLabels.Add("Category");
pivotTable.Values.Add("Amount");

// 设置透视表的筛选条件
var pivotFilter = pivotTable.PivotFilters.Add(XLPivotFilterType.CaptionEqual, "Category 1");
pivotFilter.ShowBlankItems = false;

// 保存Excel文件
workbook.SaveAs("Report.xlsx");