def test_xlsx_xlrd(self):
with open(os.path.join(BASE, 'files', 'test.xlsx')) as fp:
sheets = xlrd_tools.xlsx_xlrd(fp)
sheet = sheets.popitem()[1]
assert sheet[0][0] == {
'field': 'one',
'id': 'one',
'name': 'one',
'sortable': True
}
assert sheet[0][1] == {
'field': 'two',
'id': 'two',
'name': 'two',
'sortable': True
}
assert sheet[0][2] == {
'field': 'three',
'id': 'three',
'name': 'three',
'sortable': True
}
assert sheet[1][0] == {'one': 'a', 'two': 'b', 'three': 'c'}
assert sheet[1][1] == {'one': 1.0, 'two': 2.0, 'three': 3.0}
assert sheet[1][2] == {
'one': u'wierd\\x97',
'two': u'char\\x98',
'three': u'set\\x99'
}
def test_xlsx_xlrd(self):
with open(os.path.join(BASE, 'files', 'test.xlsx')) as fp:
headers, data = xlrd_tools.xlsx_xlrd(fp)
assert headers[0] == {'field': 'one', 'id': 'one', 'name': 'one', 'sortable': True}
assert headers[1] == {'field': 'two', 'id': 'two', 'name': 'two', 'sortable': True}
assert headers[2] == {'field': 'three', 'id': 'three', 'name': 'three', 'sortable': True}
assert data[0] == {'one': 'a', 'two': 'b', 'three': 'c'}
assert data[1] == {'one': 1.0, 'two': 2.0, 'three': 3.0}
assert data[2] == {'one': u'wierd\\x97', 'two': u'char\\x98','three': u'set\\x99'}
def test_xlsx_xlrd(self):
with open(os.path.join(BASE, "files", "test.xlsx")) as fp:
sheets = xlrd_tools.xlsx_xlrd(fp)
sheet = sheets.popitem()[1]
assert sheet[0][0] == {"field": "one", "id": "one", "name": "one", "sortable": True}
assert sheet[0][1] == {"field": "two", "id": "two", "name": "two", "sortable": True}
assert sheet[0][2] == {"field": "three", "id": "three", "name": "three", "sortable": True}
assert sheet[1][0] == {"one": "a", "two": "b", "three": "c"}
assert sheet[1][1] == {"one": 1.0, "two": 2.0, "three": 3.0}
assert sheet[1][2] == {"one": u"wierd\\x97", "two": u"char\\x98", "three": u"set\\x99"}