Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
<xsd:simpleType name="DataTypeType" >
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Number" />
<xsd:enumeration value="Bin.Hex" />
<xsd:enumeration value="Boolean" />
<xsd:enumeration value="DateTime" />
<xsd:enumeration value="Float" />
<xsd:enumeration value="Integer" />
<xsd:enumeration value="I1" />
<xsd:enumeration value="I2" />
<xsd:enumeration value="I8" />
<xsd:enumeration value="Int" />
<xsd:enumeration value="String" />
<xsd:enumeration value="UI1" />
<xsd:enumeration value="UI2" />
<xsd:enumeration value="UI4" />
<xsd:enumeration value="UI8" />
</xsd:restriction>
</xsd:simpleType>