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.