var rangeAddress = $"{rowNumber}:{rowNumber}";
var expression = worksheet.ConditionalFormatting
.AddExpression(new ExcelAddress(rangeAddress));
expression.Style.NumberFormat.Format = "0.00";
// not trying to be lazy here - you already have your formula.
expression.Formula = "IF(something)";
1 回答
鉴于
worksheet
是ExcelWorksheet
并且rowNumber
是......