guardar campo fecha desde excel a una bd

[razpeitia]

Tienes que usar la función xldate_as_tuple.

Ejemplo de uso:

Código Python:

import datetime
import xlrd
 
book = xlrd.open_workbook("myfile.xls")
sheet = book.sheet_by_index(0)
cell = sheet.cell(5, 19) # type, <class 'xlrd.sheet.Cell'>
 
 
if sheet.cell(5, 19).ctype == 3: # 3 means 'xldate' , 1 means 'text'
    ms_date_number = sheet.cell_value(5, 19) # Correct option 1
    ms_date_number = sheet.cell(5, 19).value # Correct option 2
 
    year, month, day, hour, minute, second = xlrd.xldate_as_tuple(ms_date_number, 
        book.datemode)
    py_date = datetime.datetime(year, month, day, hour, minute, second)
 

Fuente: http://stackoverflow.com/questions/3...ldate-as-tuple