DataType Property

Microsoft Office Web Components Object Model

Show All

DataType Property

       

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.