Conditional Formatting Top 10
Output: ConditionalFormattingTop10.xlsx
public void Run()
{
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.Columns[0].WidthCharacters = 55;
worksheet.Columns.SetWidthCharacters("B", "F", 5);
worksheet["A1"].Value = "Top 3 Fill Accent3";
worksheet.GetRange("B1:F1").SetValue(new int[] { 1, 2, 3, 4, 5 });
var ruleB1 = worksheet.ConditionalFormattings.AddTop10("B1:F1", 3);
ruleB1.Fill = CellFill.CreateSolidFill(SpreadsheetColor.Accent3);
worksheet["A2"].Value = "Bottom 2 Fill Accent2";
worksheet.GetRange("B2:F2").SetValue(new int[] { 1, 2, 3, 4, 5 });
var ruleB2 = worksheet.ConditionalFormattings.AddTop10("B2:F2", 2);
ruleB2.Fill = CellFill.CreateSolidFill(SpreadsheetColor.Accent2);
ruleB2.Bottom = true;
workbook.SaveAs("ConditionalFormattingTop10.xlsx");
}