Class XlsChartDropBar

Namespace

Spire.Xls.Core.Spreadsheet.Charts

Assembly

Spire.XLS.dll

public class XlsChartDropBar : XlsObject, IExcelApplication, IDisposable, IChartDropBar, IChartFillBorder

Inheritance

object

XlsObject

XlsChartDropBar

Implements

IExcelApplication

IDisposable

IChartDropBar

IChartFillBorder

Derived

ChartDropBar

Inherited Members

XlsObject.m_bIsDisposed

XlsObject.AddReference()

XlsObject.ReleaseReference()

XlsObject.Dispose()

XlsObject.OnDispose()

XlsObject.FindParent(Type)

XlsObject.FindParent(Type, bool)

XlsObject.FindParent(object, Type)

XlsObject.FindParent(object, Type, bool)

XlsObject.FindParents(Type[])

XlsObject.FindParent(Type[])

XlsObject.SetParent(object)

XlsObject.CheckDisposed()

XlsObject.Parent

XlsObject.ReferenceCount

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

BackGroundColor

Gets or sets background color.

public Color BackGroundColor { get; set; }

Property Value

Color

BackGroundColorObject

public OColor BackGroundColorObject { get; }

Property Value

OColor

BackGroundKnownColor

Gets or sets background color.

public ExcelColors BackGroundKnownColor { get; set; }

Property Value

ExcelColors

Fill

Represents XlsFill options. Read-only. The following code illustrates the use of Fill property:

//Create worksheetWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");Worksheet worksheet = workbook.Worksheets[0];//Create chart and set rangeIChart chart = worksheet.Charts.Add();chart.DataRange = worksheet.Range["B2:C6"];//Set chart typechart.ChartType = ExcelChartType.Column3DClustered;//Gets fill options for the chart elementIShapeFill fillChart = chart.ChartArea.Fill;fillChart.FillType = ShapeFillType.Gradient;fillChart.BackColor = Color.FromArgb(205, 217, 234);fillChart.ForeColor = Color.White;//Save to fileworkbook.SaveToFile("Chart.xlsx");

public IShapeFill Fill { get; }

Property Value

IShapeFill

ForeGroundColor

public Color ForeGroundColor { get; set; }

Property Value

Color

ForeGroundColorObject

Gets or sets foreground color.

public OColor ForeGroundColorObject { get; }

Property Value

OColor

ForeGroundKnownColor

public ExcelColors ForeGroundKnownColor { get; set; }

Property Value

ExcelColors

Format3D

public Format3D Format3D { get; }

Property Value

Format3D

GapWidth

[Obsolete("get and set are not implemented")]
public int GapWidth { get; set; }

Property Value

int

HasFormat3D

public bool HasFormat3D { get; }

Property Value

bool

HasInterior

This property indicates whether interior object was created. Read-only. The following code illustrates the use of HasInterior property:

//Create worksheetWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");Worksheet worksheet = workbook.Worksheets[0];//Create chart and set rangeIChart chart = worksheet.Charts.Add();chart.DataRange = worksheet.Range["B2:C6"];//Set chart typechart.ChartType = ExcelChartType.Column3DClustered;//Create a fill border and set interior valueIChartFillBorder fillBorder = chart.ChartArea;chart.ChartArea.Interior.ForegroundColor = Color.Yellow;//True if the chart element has interior formattingif (fillBorder.HasInterior){//Your Code Here}//Save to fileworkbook.SaveToFile("Chart.xlsx");

public bool HasInterior { get; }

Property Value

bool

HasLineProperties

This property indicates whether line formatting object was created. Read-only. The following code illustrates the use of HasLineProperties property:

//Create worksheetWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");Worksheet worksheet = workbook.Worksheets[0];//Create chart and set rangeIChart chart = worksheet.Charts.Add();chart.DataRange = worksheet.Range["B2:C6"];//Set chart typechart.ChartType = ExcelChartType.Column3DClustered;//Create a fill border and set line border valueIChartFillBorder fillBorder = chart.ChartArea;chart.ChartArea.Border.Color = Color.Yellow;//True if the chart element has line formattingif (fillBorder.HasLineProperties){//Your Code Here}//Save to fileworkbook.SaveToFile("Chart.xlsx");

public bool HasLineProperties { get; }

Property Value

bool

HasShadow

public bool HasShadow { get; }

Property Value

bool

Interior

Returns object, that represents area properties. Read-only. The following code illustrates the use of Interior property:

//Create worksheetWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");Worksheet worksheet = workbook.Worksheets[0];//Create chart and set rangeIChart chart = worksheet.Charts.Add();chart.DataRange = worksheet.Range["B2:C6"];//Set chart typechart.ChartType = ExcelChartType.Column3DClustered;//Gets interior formatting properties for the chart elementIChartInterior chartInterior = chart.ChartArea.Interior;chartInterior.BackgroundColor = Color.Beige;chartInterior.Pattern = ExcelPatternType.DarkDownwardDiagonal;//Save to fileworkbook.SaveToFile("Chart.xlsx");

public IChartInterior Interior { get; }

Property Value

IChartInterior

IsAutomaticFormat

Gets if use automatic format.

public bool IsAutomaticFormat { get; set; }

Property Value

bool

LineProperties

Returns object, that represents line properties. Read-only. The following code illustrates the use of LineProperties:

//Create worksheetWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");Worksheet worksheet = workbook.Worksheets[0];//Create chart and set rangeIChart chart = worksheet.Charts.Add();chart.DataRange = worksheet.Range["B2:C6"];//Set chart typechart.ChartType = ExcelChartType.Column3DClustered;//Gets line formatting properties for the chart elementIChartBorder border = chart.PlotArea.Border;border.Pattern = ChartLinePatternType.DashDotDot;border.Color = Color.Orange;//Save to fileworkbook.SaveToFile("Chart.xlsx");

public ChartBorder LineProperties { get; }

Property Value

ChartBorder

Pattern

Gets pattern.

public ExcelPatternType Pattern { get; set; }

Property Value

ExcelPatternType

Shadow

public ChartShadow Shadow { get; }

Property Value

ChartShadow

Visible

Gets or sets visiblity.

public bool Visible { get; set; }

Property Value

bool

Methods

Clone(object)

public XlsChartDropBar Clone(object parent)

Parameters

parent object

Returns

XlsChartDropBar