Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)
Syntax
'Declaration
Function OLEObjects ( _
Index As Object _
) As Object
Object OLEObjects(
Object Index
)
Parameters
- Index
Type: System.Object
The name or number of the OLE object.
Return Value
Type: System.Object
Examples
The following code example uses the OLEObjects method to get the collection of OLE objects on the current Microsoft.Office.Tools.Excel.ChartSheet.
Private Sub DisplayOLEObjectsCount()
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
Dim oleObjects1 As Excel.OLEObjects = _
CType(Me.OLEObjects(), Excel.OLEObjects)
MsgBox("The chart sheet has " & oleObjects1.Count & _
" OLE objects.")
End Sub
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.");
}
.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.