|
Python Connector for Microsoft Excel Online Data types - Python Connector for Microsoft Excel Online |
|
|
|
Python Connector for Microsoft Excel Online Data types - Python Connector for Microsoft Excel Online |
|
The following table describes the supported Microsoft Excel Online data types and their mapping to the Python data types. The type codes returned in the description cursor attribute can be used in the addtypecast() cursor method.
| Excel Online data type | Type code | Python data type |
|---|---|---|
|
Whole Number |
3013 |
int |
|
Decimal Number |
3008 |
float |
|
Currency |
3005 |
float |
|
Boolean |
3004 |
bool |
|
Text |
3017 |
str |
|
Date |
3007 |
datetime.datetime |