Excel.Interfaces.ChartDataTableLoadOptions interface

Package:

excel

Represents the data table object of a chart.

Remarks

[ API set: ExcelApi 1.14 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
format	Represents the format of a chart data table, which includes fill, font, and border format.
showHorizontalBorder	Specifies whether to display the horizontal border of the data table.
showLegendKey	Specifies whether to show the legend key of the data table.
showOutlineBorder	Specifies whether to display the outline border of the data table.
showVerticalBorder	Specifies whether to display the vertical border of the data table.
visible	Specifies whether to show the data table of the chart.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

format

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

format?: Excel.Interfaces.ChartDataTableFormatLoadOptions;

Property Value

Excel.Interfaces.ChartDataTableFormatLoadOptions

Remarks

[ API set: ExcelApi 1.14 ]

showHorizontalBorder

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

showHorizontalBorder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

showLegendKey

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

showLegendKey?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

showOutlineBorder

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

showOutlineBorder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

showVerticalBorder

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

showVerticalBorder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

visible

Specifies whether to show the data table of the chart.

visible?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]