def XLRDParser(self, infile):
    "\n        Parses old excel file into tableData object. Only first sheet.\n\n        Dont use this directly, use \n            td=TableData('xsl', infile)\n            td=TableData.load=table(infile)\n        instead\n        \n        xlrd uses UTF16. What comes out of here?\n        \n        TO DO: \n        1. better tests for\n        -Unicode issues not tested\n        -Excel data fields change appearance\n        2. conversion/transformation stuff\n        "
    import xlrd
    import xlrd.sheet
    from xlrd.sheet import ctype_text
    self.table = []
    self.verbose(('xlrd infile %s' % infile))
    wb = xlrd.open_workbook(filename=infile, on_demand=True)
    sheet = wb.sheet_by_index(0)
    for r in range(0, sheet.nrows):
        row = []
        for c in range(sheet.ncols):
            cell = sheet.cell(r, c)
            cellTypeStr = ctype_text.get(cell.ctype, 'unknown type')
            val = cell.value
            if (cellTypeStr == 'number'):
                val = int(float(val))
            elif (cellTypeStr == 'xldate'):
                val = xlrd.xldate.xldate_as_datetime(val, 0)
            row.append(val)
        self.table.append(row)
    wb.unload_sheet(0)
Parses old excel file into tableData object. Only first sheet.

Dont use this directly, use 
    td=TableData('xsl', infile)
    td=TableData.load=table(infile)
instead

xlrd uses UTF16. What comes out of here?

TO DO: 
1. better tests for
-Unicode issues not tested
-Excel data fields change appearance
2. conversion/transformation stuff
def XLRDParser(self, infile):
    "\n        Parses old excel file into tableData object. Only first sheet.\n\n        Dont use this directly, use \n            td=TableData('xsl', infile)\n            td=TableData.load=table(infile)\n        instead\n        \n        xlrd uses UTF16. What comes out of here?\n        \n        TO DO: \n        1. better tests for\n        -Unicode issues not tested\n        -Excel data fields change appearance\n        2. conversion/transformation stuff\n        "
    import xlrd
    import xlrd.sheet
    from xlrd.sheet import ctype_text
    self.table = []
    self.verbose(('xlrd infile %s' % infile))
    wb = xlrd.open_workbook(filename=infile, on_demand=True)
    sheet = wb.sheet_by_index(0)
    for r in range(0, sheet.nrows):
        row = []
        for c in range(sheet.ncols):
            cell = sheet.cell(r, c)
            cellTypeStr = ctype_text.get(cell.ctype, 'unknown type')
            val = cell.value
            if (cellTypeStr == 'number'):
                val = int(float(val))
            elif (cellTypeStr == 'xldate'):
                val = xlrd.xldate.xldate_as_datetime(val, 0)
            row.append(val)
        self.table.append(row)
    wb.unload_sheet(0)