[PYTHON API] Adding an new row with date column
Using the python SDK, I'm having trouble adding a new row to a sheet where one of the columns is a DATE column. For ex, doing:
cell.value = datetime.datetime.now()
with the column type as DATE doesn't assign anything to the column, and the request comes back with an error since the cell.value is empty.
If online I switch the column type to TEXT NUMBER and do:
cell.value = str(datetime.datetime.now())
then it completes successfully. I'm not sure what I'm doing wrong. Looking into the source of the python sdk seems to indicate that a datetime.datetime object is what should be passed, but when stepping through the code, it does some type checking and skips it setter since it's not realizing at the time that the cell is from a DATE column. Any help would be appreciated.