ChartSheetBase.HasDataTable Property

Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheetBase has a data table.

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

Syntax

'Declaration
Public Property HasDataTable As Boolean

public bool HasDataTable { get; set; }

Property Value

Type: System.Boolean
true if the Microsoft.Office.Tools.Excel.ChartSheetBase has a data table.

Examples

The following code example uses the HasDataTable and DataTable properties to display a data table in the current Microsoft.Office.Tools.Excel.ChartSheetBase 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

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace