Table of Contents

Class XlsChartDataTable

Namespace
Spire.Xls.Core.Spreadsheet.Charts
Assembly
Spire.XLS.dll
public class XlsChartDataTable : XlsObject, IDisposable, IChartDataTable, IFont, IExcelApplication, IOptimizedUpdate
Inheritance
XlsChartDataTable
Implements
Derived
Inherited Members

Properties

BackgroundMode

Display mode of the background.

public ChartBackgroundMode BackgroundMode { get; set; }

Property Value

ChartBackgroundMode

Color

Gets or sets color.

public Color Color { get; set; }

Property Value

Color

FontName

Returns or sets the font name. Read / write string.

public string FontName { get; set; }

Property Value

string

HasBorders

Indicate whether data table has borders.

public bool HasBorders { get; set; }

Property Value

bool

HasHorzBorder

Indicates whether data table has horizontal border.

public bool HasHorzBorder { get; set; }

Property Value

bool

HasVertBorder

Indicates whether data table has vertical border.

public bool HasVertBorder { get; set; }

Property Value

bool

IsAutoColor

Indicates whether color has automatic color. Read-only.

public bool IsAutoColor { get; }

Property Value

bool

IsBold

True if the font is bold. Read / write Boolean.

public bool IsBold { get; set; }

Property Value

bool

IsItalic

True if the font style is italic. Read / write Boolean.

public bool IsItalic { get; set; }

Property Value

bool

IsStrikethrough

True if the font is struck through with a horizontal line. Read / write Boolean

public bool IsStrikethrough { get; set; }

Property Value

bool

IsSubscript

True if the font is formatted as subscript. False by default. Read / write Boolean.

public bool IsSubscript { get; set; }

Property Value

bool

IsSuperscript

True if the font is formatted as superscript. False by default. Read/write Boolean

public bool IsSuperscript { get; set; }

Property Value

bool

KnownColor

Returns or sets the primary color of the object.

public ExcelColors KnownColor { get; set; }

Property Value

ExcelColors

ShowSeriesKeys

Indicates whehter series keys in the data table.

public bool ShowSeriesKeys { get; set; }

Property Value

bool

Size

Returns or sets the size of the font. Read / write Variant.

public double Size { get; set; }

Property Value

double

StrikethroughType

public string StrikethroughType { get; set; }

Property Value

string

Underline

Returns or sets the type of underline applied to the font.

public FontUnderlineType Underline { get; set; }

Property Value

FontUnderlineType

VerticalAlignment

Returns or sets font vertical alignment.

public FontVertialAlignmentType VerticalAlignment { get; set; }

Property Value

FontVertialAlignmentType

Methods

BeginUpdate()

public void BeginUpdate()

Clone(object)

public XlsChartDataTable Clone(object parent)

Parameters

parent object

Returns

XlsChartDataTable

EndUpdate()

public void EndUpdate()

GetThemeColor(out ThemeColorType, out double)

public bool GetThemeColor(out ThemeColorType type, out double tint)

Parameters

type ThemeColorType
tint double

Returns

bool

SetThemeColor(ThemeColorType, double)

public void SetThemeColor(ThemeColorType type, double tint)

Parameters

type ThemeColorType
tint double