ChartSheet.DataTable Property

Gets a DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheet data table.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
ReadOnly Property DataTable As DataTable
    Get

DataTable DataTable { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.DataTable
A DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheet data table.

Examples

The following code example uses the DataTable property of the current Microsoft.Office.Tools.Excel.ChartSheet to display a data table in the chart with a border outline.

Private Sub DisplayDataTable()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn
    Me.HasDataTable = True
    Me.DataTable.HasBorderOutline = True
End Sub

private void DisplayDataTable()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    this.HasDataTable = true;
    this.DataTable.HasBorderOutline = true;
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace