DataType Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

DataType property as it applies to the SchemaField and SchemaParameter objects.

Returns or sets the specified field’s data type. Read/write ADO DataTypeEnum.

expression.DataType

expression   Required. An expression that returns one of the above objects.

DataType property as it applies to the PivotField object.

Returns the specified field’s data type. Read-only ADO DataTypeEnum.

expression.DataType

expression   Required. An expression that returns a **PivotField**object.

DataType property as it applies to the Spreadsheet object.

Specifies the spreadsheet’s data format and source, as shown in the following table. Read/write String.

Value Meaning
HTMLURL The data source is the URL specified by the HTMLURL property.
HTMLData The data source is the string specified by the HTMLData property.
CSVURL The data source is the URL specified by the CSVURL property.
CSVData The data source is the string specified by the CSVData property.

expression.DataType

expression   Required. An expression that returns a Spreadsheet object.