XlParameterDataType enumeration
Office 2013 and later
Specifies the data type of a query parameter.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlParamTypeUnknown | Type unknown. | |
| xlParamTypeChar | String. | |
| xlParamTypeNumeric | Numeric. | |
| xlParamTypeDecimal | Decimal. | |
| xlParamTypeInteger | Integer. | |
| xlParamTypeSmallInt | Small integer. | |
| xlParamTypeFloat | Float. | |
| xlParamTypeReal | Real. | |
| xlParamTypeDouble | Double. | |
| xlParamTypeVarChar | Variable-length string. | |
| xlParamTypeDate | Date. | |
| xlParamTypeTime | Time. | |
| xlParamTypeTimestamp | Time stamp. | |
| xlParamTypeLongVarChar | Long string. | |
| xlParamTypeBinary | Binary. | |
| xlParamTypeVarBinary | Variable-length binary. | |
| xlParamTypeLongVarBinary | Long binary. | |
| xlParamTypeBigInt | Big integer. | |
| xlParamTypeTinyInt | Tiny integer. | |
| xlParamTypeBit | Bit. | |
| xlParamTypeWChar | Unicode character string. |
Show: