Class XlsChartInterior

Namespace

Spire.Xls.Core.Spreadsheet.Charts

Assembly

Spire.XLS.dll

public class XlsChartInterior : XlsObject, IExcelApplication, IDisposable, IChartInterior, ICloneParent

Inheritance

object

XlsObject

XlsChartInterior

Implements

IExcelApplication

IDisposable

IChartInterior

ICloneParent

Derived

ChartInterior

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

Background color.

public Color BackgroundColor { get; set; }

Property Value

Color

BackgroundColorObject

Background color (RGB).

public OColor BackgroundColorObject { get; }

Property Value

OColor

BackgroundKnownColor

Background excel color.

public ExcelColors BackgroundKnownColor { get; set; }

Property Value

ExcelColors

ForegroundColor

Foreground color.

public Color ForegroundColor { get; set; }

Property Value

Color

ForegroundColorObject

Foreground color (RGB).

public OColor ForegroundColorObject { get; }

Property Value

OColor

ForegroundKnownColor

Foreground excel color.

public ExcelColors ForegroundKnownColor { get; set; }

Property Value

ExcelColors

Pattern

Area pattern. The following code illustrates the use of Pattern property:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart and set range
IChart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["B2:C6"];

//Set chart type
chart.ChartType = ExcelChartType.Cone3DClustered;

//Set the pattern of the chart
chart.ChartArea.Interior.Pattern = ExcelPatternType.Angle;

//Save to file
workbook.SaveToFile("Chart.xlsx");

public ExcelPatternType Pattern { get; set; }

Property Value

ExcelPatternType

SwapColorsOnNegative

Foreground and background are swapped when the data value is negative.

public bool SwapColorsOnNegative { get; set; }

Property Value

bool

UseDefaultFormat

Indicates whether use default format.

public bool UseDefaultFormat { get; set; }

Property Value

bool

Methods

Clone(object)

public XlsChartInterior Clone(object parent)

Parameters

parent object

Returns

XlsChartInterior

Clone(object, bool)

public XlsChartInterior Clone(object parent, bool isFrameClone)

Parameters

parent object

isFrameClone bool

Returns

XlsChartInterior

InitForFrameFormat(bool, bool, bool)

[Obsolete("the method is not implemented")]
public void InitForFrameFormat(bool bIsAutoSize, bool bIs3DChart, bool bIsInteriorGray)

Parameters

bIsAutoSize bool

bIs3DChart bool

bIsInteriorGray bool

InitForFrameFormat(bool, bool, bool, bool)

[Obsolete("the method is not implemented")]
public void InitForFrameFormat(bool bIsAutoSize, bool bIs3DChart, bool bIsInteriorGray, bool bIsGray50)

Parameters

bIsAutoSize bool

bIs3DChart bool

bIsInteriorGray bool

bIsGray50 bool