[]
Specifies how a data bar is filled with color.
Use this enumeration to control whether a data bar is displayed with a solid fill or a gradient fill in conditional formatting.
public enum DataBarFillType
Public Enum DataBarFillType
worksheet.Range["A1:A3"].Value = new object[,] {
{ 10 },
{ 20 },
{ 30 }
};
IDataBar dataBar = worksheet.Range["A1:A3"].FormatConditions.AddDatabar();
dataBar.BarFillType = DataBarFillType.Gradient;
| Name | Description |
|---|---|
| Gradient | Specifies that the data bar is filled using a color gradient rather than a solid color. |
| Solid | Specifies that the data bar is filled with a uniform solid color instead of a gradient. |