docs: def formatrow(self, types, values, wanttupledate):
          """ Internal function used to clean up the incoming excel data """
          ##  Data Type Codes:
          ##  EMPTY 0
          ##  TEXT 1 a Unicode string
          ##  NUMBER 2 float
          ##  DATE 3 float
          ##  BOOLEAN 4 int; 1 means TRUE, 0 means FALSE
          ##  ERROR 5
          returnrow = []
          for i in range(len(types)):
              type,value = types[i],values[i]
              if type == 2:
                  if value == int(value):
                      value = int(value)
              elif type == 3:
                  datetuple = xlrd.xldate_as_tuple(value, self.__book__.datemode)
                  if wanttupledate:
                      value = datetuple
                  else:
                      # time only no date component
                      if datetuple[0] == 0 and datetuple[1] == 0 and \
                         datetuple[2] == 0:
                          value = "%02d:%02d:%02d" % datetuple[3:]
                      # date only, no time
                      elif datetuple[3] == 0 and datetuple[4] == 0 and \
                           datetuple[5] == 0:
                          value = "%04d-%02d-%02d" % datetuple[:3]
                      else: # full date
                          value = "%04d-%02d-%02d %02d:%02d:%02d" % datetuple
              elif type == 5:
                  value = xlrd.error_text_from_code[value]
              returnrow.append(value)
          return returnrow