DataType Element (Microsoft Excel)

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.

For a PivotTable cache, the following attributes can be specified.

Attribute Description
dt:type Optional. Contains one of the following string constants specifying the base data type of the field: Bin.Hex, Boolean, DateTime, Float, I1, I2, I8, Int, String, UI1, UI2, UI4, or UI8. If this attribute is not specified, the default type is String.
dt:maxLength Optional. Length of a string field. If this attribute is not specified, the default length for string fields is 255.

Contained In

AttributeType, PivotField, PLPivotField

Remarks

For a PivotTable field, this element contains one of the following string constants specifying the data type: Boolean, Date, Integer, Number, or Text. Boolean can be specified only when the PLExport element is specified for the PivotTable report and the report data comes from a PivotList component. If the DataType element is not specified, the default data type is Text.

Examples

See the examples in the PivotCache and PivotTable element topics.