|
Python Connector for Microsoft Excel Data types - Python Connector for Microsoft Excel |
|
|
|
Python Connector for Microsoft Excel Data types - Python Connector for Microsoft Excel |
|
The following table describes the supported Microsoft Excel 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 data type | Type code | Python data type |
|---|---|---|
|
boolean |
5027 |
bool |
|
integer |
5010 |
int |
|
float |
5016 |
float |
|
date |
5022 |
datetime.date |
|
time |
5023 |
datetime.time |
|
datetime |
5024 |
datetime.datetime |
|
string |
5001 |
str |