def test_fromxlsx():
tbl = fromxlsx('fixture/test.xlsx', 'Sheet1')
expect = (('foo', 'bar'),
('A', 1),
('B', 2),
('C', 2))
ieq(expect, tbl)
def test_toxlsx_nosheet():
tbl = (('foo', 'bar'), ('A', 1), ('B', 2), ('C', 2), (u'é',
datetime(2012, 1,
1)))
toxlsx(tbl, 'tmp/test2.xlsx')
actual = fromxlsx('tmp/test2.xlsx')
ieq(tbl, actual)
def test_fromxlsx():
tbl = fromxlsx('fixture/test.xlsx', 'Sheet1')
expect = (('foo', 'bar'),
('A', 1),
('B', 2),
('C', 2),
(u'é', datetime(2012, 1, 1)))
ieq(expect, tbl)
ieq(expect, tbl)
def test_toxlsx_nosheet():
tbl = (('foo', 'bar'),
('A', 1),
('B', 2),
('C', 2),
(u'é', datetime(2012, 1, 1)))
toxlsx(tbl, 'tmp/test2.xlsx')
actual = fromxlsx('tmp/test2.xlsx')
ieq(tbl, actual)
def test_fromxlsx():
tbl = fromxlsx('fixture/test.xlsx', 'Sheet1')
expect = (('foo', 'bar'), ('A', 1), ('B', 2), ('C', 2),
(u'é', datetime(2012, 1, 1)))
ieq(expect, tbl)
ieq(expect, tbl)