DataBar Class

Describe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the range of cells.
Inheritance Hierarchy

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: (21.7)
public class DataBar

The DataBar type exposes the following members.

Public propertyAxisColor
Gets the color of the axis for cells with conditional formatting as data bars.
Public propertyAxisPosition
Gets or sets the position of the axis of the data bars specified by a conditional formatting rule.
Public propertyBarBorder
Gets an object that specifies the border of a data bar.
Public propertyBarFillType
Gets or sets how a data bar is filled with color.
Public propertyColor
Get or set this DataBar's Color.
Public propertyDirection
Gets or sets the direction the databar is displayed.
Public propertyMaxCfvo
Get or set this DataBar's max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.
Public propertyMaxLength
Represents the max length of data bar .
Public propertyMinCfvo
Get or set this DataBar's min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.
Public propertyMinLength
Represents the min length of data bar .
Public propertyNegativeBarFormat
Gets the NegativeBarFormat object associated with a data bar conditional formatting rule.
Public propertyShowValue
Get or set the flag indicating whether to show the values of the cells on which this data bar is applied. Default value is true.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToImage
Render data bar in cell to image byte array.
Public methodToString (Inherited from Object.)

//Instantiating a Workbook object
Workbook workbook = new Workbook();

Worksheet sheet = workbook.Worksheets[0];

//Adds an empty conditional formatting
int index = sheet.ConditionalFormattings.Add();

FormatConditions fcs = sheet.ConditionalFormattings[index];

//Sets the conditional format range.
CellArea ca = new CellArea();

ca.StartRow = 0;

ca.EndRow = 2;

ca.StartColumn = 0;

ca.EndColumn = 0;


//Adds condition.
int idx = fcs.AddCondtion(FormatConditionType.DataBar);


FormatCondition cond = fcs[idx];

//Get Databar
DataBar dataBar = cond.DataBar;

dataBar.Color = Color.Orange;

//Set Databar properties
dataBar.MinCfvo.Type = FormatConditionValueType.Percentile;

dataBar.MinCfvo.Value = 30;

dataBar.ShowValue = false;

dataBar.BarBorder.Type = DataBarBorderType.DataBarBorderSolid;

dataBar.BarBorder.Color = Color.Plum;

 dataBar.BarFillType = DataBarFillType.DataBarFillSolid;

 dataBar.AxisColor = Color.Red;

 dataBar.AxisPosition = DataBarAxisPosition.DataBarAxisMidpoint;

 dataBar.NegativeBarFormat.ColorType = DataBarNegativeColorType.DataBarColor;

 dataBar.NegativeBarFormat.Color = Color.White;

 dataBar.NegativeBarFormat.BorderColorType = DataBarNegativeColorType.DataBarColor;

 dataBar.NegativeBarFormat.BorderColor = Color.Yellow;

//Put Cell Values
Aspose.Cells.Cell cell1 = sheet.Cells["A1"];


Aspose.Cells.Cell cell2 = sheet.Cells["A2"];


Aspose.Cells.Cell cell3 = sheet.Cells["A3"];


//Saving the Excel file


'Instantiating a Workbook object
Dim workbook As New Workbook()

Dim sheet As Worksheet = workbook.Worksheets(0)

'Adds an empty conditional formatting
Dim index As Integer = sheet.ConditionalFormattings.Add()

Dim fcs As FormatConditions = sheet.ConditionalFormattings(index)

'Sets the conditional format range.
Dim ca As New CellArea()

ca.StartRow = 0

ca.EndRow = 2

ca.StartColumn = 0

ca.EndColumn = 0


'Adds condition.
Dim idx As Integer = fcs.AddCondtion(FormatConditionType.DataBar)


Dim cond As FormatCondition = fcs(idx)

'Get Databar
Dim dataBar As DataBar = cond.DataBar

dataBar.Color = Color.Orange

'Set Databar properties
dataBar.MinCfvo.Type = FormatConditionValueType.Percentile

dataBar.MinCfvo.Value = 30

dataBar.ShowValue = False

dataBar.BarBorder.Type = DataBarBorderType.DataBarBorderSolid

dataBar.BarBorder.Color = Color.Plum

 dataBar.BarFillType = DataBarFillType.DataBarFillSolid

 dataBar.AxisColor = Color.Red

 dataBar.AxisPosition = DataBarAxisPosition.DataBarAxisMidpoint

 dataBar.NegativeBarFormat.ColorType = DataBarNegativeColorType.DataBarColor

 dataBar.NegativeBarFormat.Color = Color.White

 dataBar.NegativeBarFormat.BorderColorType = DataBarNegativeColorType.DataBarColor

 dataBar.NegativeBarFormat.BorderColor = Color.Yellow

'Put Cell Values
Dim cell1 As Aspose.Cells.Cell = sheet.Cells("A1")


Dim cell2 As Aspose.Cells.Cell = sheet.Cells("A2")


Dim cell3 As Aspose.Cells.Cell = sheet.Cells("A3")


'Saving the Excel file
See Also