|
Python Connector for Google Sheets Data types - Python Connector for Google Sheets |
|
|
|
Python Connector for Google Sheets Data types - Python Connector for Google Sheets |
|
The following table describes the supported Google Sheets 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.
| Google Sheets data type | Type code | Python data type |
|---|---|---|
|
Integer Number |
3013 |
int |
|
Decimal Number |
3008 |
float |
|
Checkbox |
3004 |
bool |
|
Text |
3017 |
str |
|
Date and time |
3007 |
datetime.datetime |