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)
def test_ole2datetime():
actual = ole2datetime(60000)
assert actual == datetime(2064, 4, 8)
assert_raises(Exception, ole2datetime, 60)