Excel.Interfaces.ChartDataTableLoadOptions interface

Represents the data table object of a chart.

Remarks

[ API set: ExcelApi 1.14 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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 load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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

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 ]