def parseExcel(filepath, header=None, indexCol=0, dateCol=0, sheetname=None): from pandas.core.datetools import ole2datetime try: import xlrd except: raise Exception('Sorry, you do not have xlrd.') book = xlrd.open_workbook(filepath) sheet = book.sheet_by_name(sheetname) data = [sheet.row_values(i) for i in range(sheet.nrows)] if dateCol is not None: for row in data: try: row[dateCol] = ole2datetime(row[dateCol]) except Exception: pass return simpleParser(data, header=header, indexCol=indexCol)
def parseExcel(filepath, header = None, indexCol = 0, dateCol = 0, sheetname = None): from pandas.core.datetools import ole2datetime try: import xlrd except: raise Exception('Sorry, you do not have xlrd.') book = xlrd.open_workbook(filepath) sheet = book.sheet_by_name(sheetname) data = [sheet.row_values(i) for i in range(sheet.nrows)] if dateCol is not None: for row in data: try: row[dateCol] = ole2datetime(row[dateCol]) except Exception: pass return simpleParser(data, header = header, indexCol = indexCol)
def test_ole2datetime(): actual = ole2datetime(60000) assert actual == datetime(2064, 4, 8) assert_raises(Exception, ole2datetime, 60)