Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| Excel Services (OData V3) | Excel Services (OData V4) | CData Schema |
| Edm.Binary | Edm.Binary | binary |
| Edm.Boolean | Edm.Boolean | bool |
| Edm.DateTime | Edm.DateTimeOffset | datetime |
| Edm.Double | Edm.Double | double |
| Edm.Guid | Edm.Guid | guid |
| Edm.Int32 | Edm.Int32 | int |
| Edm.String | Edm.String | string |
| Edm.TimeOfDay | Edm.TimeOfDay | time |