Partager via


OleItem Class

Defines the OleItem Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:oleItem.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.OleItem

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(DdeValues), FileFormatVersions.Office2010)> _
Public Class OleItem _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As OleItem
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(DdeValues), FileFormatVersions.Office2010)]
public class OleItem : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • DdeValues <x14:values>

2.4.23 oleItem

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

A CT_OleItem element that specifies an OLE data item ([ISO/IEC-29500-1] section 18.14) with associated cached values. See External Workbook References under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="oleItem" type="CT_OleItem"/>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.46 CT_OleItem

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

Referenced by: oleItem

A complex type that specifies an OLE data item ([ISO/IEC-29500-1] section 18.14) with associated cached values.

Child Elements:

values : A CT_DdeValues ([ISO/IEC-29500-4] section A.2) element that specifies the cached values.

Attributes:

name : A ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the name of the OLE data item ([ISO/IEC-29500-1] section 18.14).

icon : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLE data item ([ISO/IEC-29500-1] section 18.14) is represented as an icon.

Value

Meaning

FALSE

The OLE data item ([ISO/IEC-29500-1] section 18.14) is not represented as an icon.

TRUE

The OLE data item ([ISO/IEC-29500-1] section 18.14) is represented as an icon.

advise : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the application requests that the OLE data source ([ISO/IEC-29500-1] section 18.14) provides notifications when the source data changes.

Value

Meaning

FALSE

The application does not request to be notified when the source data changes.

TRUE

The application requests to be notified when the source data changes.

preferPic : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLE data item ([ISO/IEC-29500-1] section 18.14) is an image.

Value

Meaning

FALSE

The OLE data item ([ISO/IEC-29500-1] section 18.14) is not an image.

TRUE

The OLE data item ([ISO/IEC-29500-1] section 18.14) is an image.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_OleItem">

<xsd:sequence>

<xsd:element name="values" type="x:CT_DdeValues" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

<xsd:attribute name="name" type="x:ST_Xstring" use="required"/>

<xsd:attribute name="icon" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="advise" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="preferPic" type="xsd:boolean" use="optional" default="false"/>

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

OleItem Members

DocumentFormat.OpenXml.Office2010.Excel Namespace