code: def _xls2code(self, worksheet, tab):
          
  
          def xlrddate2datetime(xlrd_date):
              """Returns datetime from xlrd_date"""
  
              try:
                  xldate_tuple = xlrd.xldate_as_tuple(xlrd_date,
                                                      self.workbook.datemode)
                  return datetime(xldate_tuple)
  
              except (ValueError, TypeError):
                  return ''
  
          type2mapper = {
              0: lambda x: None,  # Empty cell
              1: lambda x: str(x),  # Text cell
              2: lambda x: str(x),  # Number cell
              3: xlrddate2datetime,  # Date
              4: lambda x: str(bool(x)),  # Boolean cell
              5: lambda x: str(x),  # Error cell
              6: lambda x: None,  # Blank cell
          }
  
          rows, cols = worksheet.nrows, worksheet.ncols
          for row, col in product(xrange(rows), xrange(cols)):
              cell_type = worksheet.cell_type(row, col)
              cell_value = worksheet.cell_value(row, col)
  
              key = row, col, tab
              mapper = type2mapper[cell_type]
              self.code_array[key] = mapper(cell_value)
docs: Updates code in xls code_array