1import os
2
3from pyexcel_xlsx import get_data
4
5from nose.tools import eq_
6
7
8def test_hidden_row():
9    data = get_data(
10        os.path.join("tests", "fixtures", "hidden.xlsx"),
11        skip_hidden_row_and_column=True,
12        library="pyexcel-xlsx",
13    )
14    expected = [[1, 2], [7, 9]]
15    eq_(data["Sheet1"], expected)
16
17
18def test_complex_hidden_sheets():
19    data = get_data(
20        os.path.join("tests", "fixtures", "complex_hidden_sheets.xlsx"),
21        skip_hidden_row_and_column=True,
22        library="pyexcel-xlsx",
23    )
24    expected = [[1, 3, 5, 7, 9], [31, 33, 35, 37, 39], [61, 63, 65, 67]]
25    eq_(data["Sheet1"], expected)
26