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.
Applies to | PivotField Object | SchemaField Object | SchemaParameter Object | Spreadsheet Object