Conditional Formatting Data Bar
Output: ConditionalFormattingDataBar.xlsx
public void Run()
{
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.Columns[0].WidthCharacters = 46;
worksheet.Columns.SetWidthCharacters("B", "F", 5);
worksheet["A1"].Value = "Default DataBar Blue";
worksheet.GetRange("B1:F1").SetValue(new int[] {1, 2, 3, 4, 5});
worksheet.ConditionalFormattings.AddDataBar("B1:F1", SpreadsheetColor.Blue);
worksheet["A2"].Value = "Custom DataBar Red Minimum:25% Maximum:75%";
worksheet.GetRange("B2:F2").SetValue(new int[] {1, 2, 3, 4, 5});
var rule = worksheet.ConditionalFormattings.AddDataBar("B2:F2", SpreadsheetColor.Red);
rule.Minimum.Type = ConditionValueType.Percent;
rule.Minimum.Value = 25;
rule.Maximum.Type = ConditionValueType.Percent;
rule.Maximum.Value = 75;
workbook.SaveAs("ConditionalFormattingDataBar.xlsx");
}