GrapeCity.Documents.Excel.Drawing.IDataTable

IDataTable Interface

Represents a chart data table.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public interface IDataTable

Public Interface IDataTable

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {"Item", "Estimated", "Actual"},
    {"Income", 63300, 57450},
    {"Expenses", 54500, 49630}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:C3"]);
chart.HasDataTable = true;
IDataTable dataTable = chart.DataTable;

Properties

Name	Description
Font	Gets the IFontFormat object for the chart data table. Use the returned font format to read or modify font settings for the text displayed in the data table.
Format	Gets the format of the chart data table. Use the returned IChartFormat object to access the fill and line formatting settings of the chart data table.
HasBorderHorizontal	Gets whether the chart data table displays horizontal cell borders. This property indicates whether horizontal border lines are shown between rows in the chart data table. The default value is `true`.
HasBorderOutline	Gets whether the chart data table has outline borders. The default value is `true`. This property indicates whether an outer border is displayed around the chart data table.
HasBorderVertical	Gets whether the chart data table has vertical cell borders. The default value is `true`. This property indicates whether vertical border lines are displayed between cells in the chart data table.
Parent	Gets the parent IChart of the data table. Use this property to access the chart that owns the current data table.
ShowLegendKey	Gets whether legend keys are shown in the chart data table. This property indicates whether the chart data table displays a legend key for each series. The default value is `true`.

Methods

Name	Description
Delete()	Deletes this chart data table. After this method is called, the data table is removed from its parent IChart.

Name

Description

Delete()

Deletes this chart data table.

After this method is called, the data table is removed from its parent IChart.