Export (0) Print
Expand All
Expand Minimize

ChartSheet.OLEObjects Method

Gets an object that represents either a single OLE object (an OLEObject) or a collection of all OLE objects (an OLEObjects collection) on the chart or sheet.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public virtual Object OLEObjects (
	[OptionalAttribute] Object Index
)

Parameters

Index

The name or number of the OLE object.

The following code example uses the OLEObjects method to get the collection of OLE objects on the current Microsoft.Office.Tools.Excel.ChartSheet.

private void DisplayOLEObjectsCount()
{
    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;

    Excel.OLEObjects oleObjects1 =
        (Excel.OLEObjects)this.OLEObjects(missing);
    MessageBox.Show("The chart sheet has " + oleObjects1.Count +
        " OLE objects.");
}

Show:
© 2014 Microsoft