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