def test_toxls_date(): expect = ( ('foo', 'bar'), (u'é', datetime(2012, 1, 1)), (u'éé', datetime(2013, 2, 22)), ) toxls(expect, 'tmp/test2.xls', 'Sheet1', styles={'bar': xlwt.easyxf(num_format_str='DD/MM/YYYY')}) actual = fromxls('tmp/test2.xls', 'Sheet1') ieq(expect, actual)
def test_fromxls(): tbl = fromxls('fixture/test.xls', 'Sheet1') expect = (('foo', 'bar'), ('A', 1), ('B', 2), ('C', 2), (u'é', datetime(2012, 1, 1))) ieq(expect, tbl) ieq(expect, tbl)
def test_toxls(): expect = (('foo', 'bar'), ('A', 1), ('B', 2), ('C', 2)) toxls(expect, 'tmp/test1.xls', 'Sheet1') actual = fromxls('tmp/test1.xls', 'Sheet1') ieq(expect, actual)
def test_fromxls_use_view(): tbl = fromxls('fixture/test.xls', 'Sheet1', use_view=False) expect = (('foo', 'bar'), ('A', 1), ('B', 2), ('C', 2), (u'é', 40909.0)) ieq(expect, tbl) ieq(expect, tbl)
def test_toxls_date(): expect = (("foo", "bar"), (u"é", datetime(2012, 1, 1)), (u"éé", datetime(2013, 2, 22))) toxls(expect, "tmp/test2.xls", "Sheet1", styles={"bar": xlwt.easyxf(num_format_str="DD/MM/YYYY")}) actual = fromxls("tmp/test2.xls", "Sheet1") ieq(expect, actual)
def test_toxls(): expect = (("foo", "bar"), ("A", 1), ("B", 2), ("C", 2)) toxls(expect, "tmp/test1.xls", "Sheet1") actual = fromxls("tmp/test1.xls", "Sheet1") ieq(expect, actual)
def test_fromxls_nosheet(): tbl = fromxls("fixture/test.xls") expect = (("foo", "bar"), ("A", 1), ("B", 2), ("C", 2), (u"é", datetime(2012, 1, 1))) ieq(expect, tbl) ieq(expect, tbl)
def test_fromxls_use_view(): tbl = fromxls("fixture/test.xls", "Sheet1", use_view=False) expect = (("foo", "bar"), ("A", 1), ("B", 2), ("C", 2), (u"é", 40909.0)) ieq(expect, tbl) ieq(expect, tbl)