虽然我非常怀疑原帖作者在六年后仍在寻找这个答案,但我可以提供以下片段,我是基于这个Java POI示例来编写的:
var conditionalFormatting = xssfSheet
.GetCTWorksheet()
.AddNewConditionalFormatting();
conditionalFormatting.sqref = "A1:B10";
var rule = conditionalFormatting.AddNewCfRule();
rule.type = ST_CfType.colorScale;
rule.priority = 1;
var colorScale = rule.AddNewColorScale();
var minValue = colorScale.AddNewCfvo();
minValue.type = ST_CfvoType.min;
minValue.val = "0";
var maxValue=colorScale.AddNewCfvo();
maxValue.type = ST_CfvoType.max;
maxValue.val = "0";
var lowColor = colorScale.AddNewColor();
var highColor = colorScale.AddNewColor();
lowColor.SetRgb(0xFC, 0xFC, 0xFF);
highColor.SetRgb(0xF8, 0x69, 0x6B);