Chart.Creator Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets the application in which this Chart was created.

public:
 property Microsoft::Office::Interop::Excel::XlCreator Creator { Microsoft::Office::Interop::Excel::XlCreator get(); };

public Microsoft.Office.Interop.Excel.XlCreator Creator { get; }

member this.Creator : Microsoft.Office.Interop.Excel.XlCreator

Public ReadOnly Property Creator As XlCreator

Property Value

XlCreator

One of the XlCreator values.

Examples

The following code example creates a Chart and then uses the Creator property to verify whether or not the chart was created by Microsoft Office Excel.

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

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

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

    if (chart1.Creator == Excel.XlCreator.xlCreatorCode)
    {
        MessageBox.Show("Chart1 was created by Microsoft Excel");
    }
}

Private Sub DisplayCreator()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    If Chart1.Creator = Excel.XlCreator.xlCreatorCode Then
        MsgBox("Chart1 was created by Microsoft Excel")
    End If
End Sub

Remarks

Because the Chart was created in Microsoft Office Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.

Applies to

다음을 통해 공유