Chart.Creator Property
Gets the application in which this Chart was created.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
ReadOnly Property Creator As XlCreator
Get
XlCreator Creator { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlCreator
One of the XlCreator values.
Remarks
Because the Chart was created in Microsoft Office Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.
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 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
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");
}
}
.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.