Exemple #1
0
def test_fromxlsx():
    tbl = fromxlsx('fixture/test.xlsx', 'Sheet1')
    expect = (('foo', 'bar'),
              ('A', 1),
              ('B', 2),
              ('C', 2))
    ieq(expect, tbl)
Exemple #2
0
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)
Exemple #3
0
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)
Exemple #4
0
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)
Exemple #5
0
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)