OleItem class

Office 2013 and later

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

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

No code example is currently available or this language may not be supported.

2.4.25 oleItem

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

An oleItem element is a CT_OleItem type element, as specified in section 2.6.46, that specifies an Object Linking and Embedding (OLE) data item, as specified in [ISO/IEC-29500-1] section 18.14, with associated cached values. See section 2.2.4.3 for how this element integrates with the Office Open XML file formats specified in [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.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.46 CT_OleItem

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: oleItem

OleItem is a complex type that specifies an OLE data item, as specified in [ISO/IEC-29500-1] section 18.14, with associated cached values.

Child Elements:

values: A CT_DdeValues element, as specified in [ISO/IEC-29500-4] section A.2, that specifies the cached values.

Attributes:

name: An ST_Xstring attribute, as specified in [ISO/IEC-29500-1] section 22.9.2.19, that specifies the name of the OLE data item.

icon: A Boolean attribute, as specified in [XMLSCHEMA2] section 3.2.2, that specifies whether the OLE data item is represented as an icon.

Value

Meaning

"false"

The OLE data item is not represented as an icon.

"true"

The OLE data item 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 (1), as specified in [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 is an image.

Value

Meaning

"false"

The OLE data item is not an image.

"true"

The OLE data item 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.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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