Add Data Bar Rule

The data bar rule in conditional formatting displays a bar in the cell on the basis of cell values entered in a range. This rule can be added using the properties and methods of the IDataBar interface.

Refer to the following example code to add data bar rule to a range of cells in a worksheet.

C#	Copy Code
// Adding Databar rule worksheet.Range["A1:A5"].Value = new object[,] { {1}, {2}, {3}, {4}, {5} }; IDataBar dataBar = worksheet.Range["A1:A5"].FormatConditions.AddDatabar(); dataBar.MinPoint.Type = ConditionValueTypes.LowestValue; dataBar.MinPoint.Value = null; dataBar.MaxPoint.Type = ConditionValueTypes.HighestValue; dataBar.MaxPoint.Value = null; dataBar.BarFillType = DataBarFillType.Solid; dataBar.BarColor.Color = Color.Green; dataBar.Direction = DataBarDirection.Context; dataBar.AxisColor.Color = Color.Red; dataBar.AxisPosition = DataBarAxisPosition.Automatic; dataBar.NegativeBarFormat.BorderColorType = DataBarNegativeColorType.Color; dataBar.NegativeBarFormat.BorderColor.Color = Color.FromRGB(128, 0, 212); dataBar.NegativeBarFormat.ColorType = DataBarNegativeColorType.Color; dataBar.NegativeBarFormat.Color.Color = Color.FromRGB(128, 0, 240); dataBar.ShowValue = false;

Copy Code

// Adding Databar rule
worksheet.Range["A1:A5"].Value = new object[,]
{
    {1},
    {2},
    {3},
    {4},
    {5}
};

IDataBar dataBar = worksheet.Range["A1:A5"].FormatConditions.AddDatabar();

dataBar.MinPoint.Type = ConditionValueTypes.LowestValue;
dataBar.MinPoint.Value = null;
dataBar.MaxPoint.Type = ConditionValueTypes.HighestValue;
dataBar.MaxPoint.Value = null;

dataBar.BarFillType = DataBarFillType.Solid;
dataBar.BarColor.Color = Color.Green;
dataBar.Direction = DataBarDirection.Context;
dataBar.AxisColor.Color = Color.Red;
dataBar.AxisPosition = DataBarAxisPosition.Automatic;
dataBar.NegativeBarFormat.BorderColorType = DataBarNegativeColorType.Color;
dataBar.NegativeBarFormat.BorderColor.Color = Color.FromRGB(128, 0, 212);
dataBar.NegativeBarFormat.ColorType = DataBarNegativeColorType.Color;
dataBar.NegativeBarFormat.Color.Color = Color.FromRGB(128, 0, 240);
dataBar.ShowValue = false;