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