1import os 2from datetime import datetime, time 3 4from nose.tools import eq_ 5from pyexcel_io._compact import OrderedDict 6 7from pyexcel_xlsx import get_data 8 9 10def test_reading(): 11 data = get_data( 12 os.path.join("tests", "fixtures", "date_field.xlsx"), 13 library="pyexcel-xlsx", 14 skip_hidden_row_and_column=False 15 ) 16 expected = OrderedDict() 17 expected.update( 18 { 19 "Sheet1": [ 20 ["Date", "Time"], 21 [ 22 datetime(year=2014, month=12, day=25), 23 time(hour=11, minute=11, second=11), 24 ], 25 [ 26 datetime(2014, 12, 26, 0, 0), 27 time(hour=12, minute=12, second=12), 28 ], 29 [ 30 datetime(2015, 1, 1, 0, 0), 31 time(hour=13, minute=13, second=13), 32 ], 33 [ 34 datetime(year=1899, month=12, day=30), 35 datetime(1899, 12, 30, 0, 0), 36 ], 37 ] 38 } 39 ) 40 expected.update({"Sheet2": []}) 41 expected.update({"Sheet3": []}) 42 eq_(data, expected) 43