Data element (CellType group)

Specifies the value of a cell. The value should be specified in the format appropriate for the Type attribute of the cell.

Usage

      
<Data
	Type="xsd:string"
	x:Ticked="[external type]"
/>

    

Element Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Child Elements

None.

Attributes

Attribute Type Required Description Possible Values
Type Anonymous required Specifies the type of data to be contained by the cell.
  • Number
  • DateTime
  • Boolean
  • String
  • Error
x:Ticked external ref optional See external namespace. See external namespace.

Definition

      
<xsd:element name="Data" minOccurs="0" >
  <xsd:complexType mixed="true">
    <xsd:sequence>
      <xsd:any processContents="skip" minOccurs="0" maxOccurs="unbounded" />
    </xsd:sequence>
    <xsd:attribute form="qualified" name="Type" use="required">
      <xsd:simpleType>
        <xsd:restriction base="xsd:string">
          <xsd:enumeration value="Number" />
          <xsd:enumeration value="DateTime" />
          <xsd:enumeration value="Boolean" />
          <xsd:enumeration value="String" />
          <xsd:enumeration value="Error" />
        </xsd:restriction>
      </xsd:simpleType>
    </xsd:attribute>
    <xsd:attribute ref="x:Ticked" />
  </xsd:complexType>
</xsd:element>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp