ExcelScript.ChartDataTable interface

Package:

ExcelScript

Represents the data table object of a chart.

Methods

getFormat()	Represents the format of a chart data table, which includes fill, font, and border format.
getShowHorizontalBorder()	Specifies whether to display the horizontal border of the data table.
getShowLegendKey()	Specifies whether to show the legend key of the data table.
getShowOutlineBorder()	Specifies whether to display the outline border of the data table.
getShowVerticalBorder()	Specifies whether to display the vertical border of the data table.
getVisible()	Specifies whether to show the data table of the chart.
setShowHorizontalBorder(showHorizontalBorder)	Specifies whether to display the horizontal border of the data table.
setShowLegendKey(showLegendKey)	Specifies whether to show the legend key of the data table.
setShowOutlineBorder(showOutlineBorder)	Specifies whether to display the outline border of the data table.
setShowVerticalBorder(showVerticalBorder)	Specifies whether to display the vertical border of the data table.
setVisible(visible)	Specifies whether to show the data table of the chart.

Method Details

getFormat()

Represents the format of a chart data table, which includes fill, font, and border format.

getFormat(): ChartDataTableFormat;

Returns

ExcelScript.ChartDataTableFormat

getShowHorizontalBorder()

Specifies whether to display the horizontal border of the data table.

getShowHorizontalBorder(): boolean;

Returns

boolean

getShowLegendKey()

Specifies whether to show the legend key of the data table.

getShowLegendKey(): boolean;

Returns

boolean

getShowOutlineBorder()

Specifies whether to display the outline border of the data table.

getShowOutlineBorder(): boolean;

Returns

boolean

getShowVerticalBorder()

Specifies whether to display the vertical border of the data table.

getShowVerticalBorder(): boolean;

Returns

boolean

getVisible()

Specifies whether to show the data table of the chart.

getVisible(): boolean;

Returns

boolean

setShowHorizontalBorder(showHorizontalBorder)

Specifies whether to display the horizontal border of the data table.

setShowHorizontalBorder(showHorizontalBorder: boolean): void;

Parameters

showHorizontalBorder

boolean

Returns

void

setShowLegendKey(showLegendKey)

Specifies whether to show the legend key of the data table.

setShowLegendKey(showLegendKey: boolean): void;

Parameters

showLegendKey

boolean

Returns

void

setShowOutlineBorder(showOutlineBorder)

Specifies whether to display the outline border of the data table.

setShowOutlineBorder(showOutlineBorder: boolean): void;

Parameters

showOutlineBorder

boolean

Returns

void

setShowVerticalBorder(showVerticalBorder)

Specifies whether to display the vertical border of the data table.

setShowVerticalBorder(showVerticalBorder: boolean): void;

Parameters

showVerticalBorder

boolean

Returns

void

setVisible(visible)

Specifies whether to show the data table of the chart.

setVisible(visible: boolean): void;

Parameters

visible

boolean

Returns

void