Excel.Interfaces.ChartDataTableLoadOptions interface

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

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 ]

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

showHorizontalBorder?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.14 ]

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

showLegendKey?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.14 ]

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

showOutlineBorder?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.14 ]

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

showVerticalBorder?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.14 ]

Specifies whether to show the data table of the chart.

visible?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.14 ]