Why, when reading from an xlsx file using the xlrd library, data with a date is obtained in float format?

Question

Django

Good afternoon! Please tell me what is the reason that after reading from the file it turns out not data, but float?

def form_valid(self, form):
        f = self.request.FILES['file']
        rb = xlrd.open_workbook(filename=None, file_contents=f.read())
        sheet = rb.sheet_by_index(0)
        vals = [sheet.row_values(rownum) for rownum in range(sheet.nrows)]

Answer 1

You need to use xldate_as_tuple.