如何在数据透视表EPPlus中应用条件格式

using OfficeOpenXml;

// 创建一个新的Excel文件
ExcelPackage package = new ExcelPackage();

// 打开现有的Excel文件
ExcelPackage package = new ExcelPackage(new FileInfo("path/to/excel/file.xlsx"));

ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; // 通过索引获取工作表
ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"]; // 通过名称获取工作表

// 创建条件格式规则
var rule = worksheet.ConditionalFormatting.AddExpression(worksheet.Cells["A1:A10"]);
rule.Formula = "A1>10"; // 设置条件表达式
rule.Style.Fill.BackgroundColor.Color = Color.Red; // 设置背景颜色

// 创建条件格式规则
var rule2 = worksheet.ConditionalFormatting.AddExpression(worksheet.Cells["B1:B10"]);
rule2.Formula = "B1<0"; // 设置条件表达式
rule2.Style.Font.Color.Color = Color.White; // 设置字体颜色
rule2.Style.Fill.BackgroundColor.Color = Color.Blue; // 设置背景颜色

package.SaveAs(new FileInfo("path/to/save/file.xlsx"));