def test_random_access_to_unknown_area(): test_content = [[1, 2]] sheet = Sheet(test_content) eq_(sheet.to_array(), test_content) expected = [[1, 2, ''], ['', '', ''], ['', '', 100]] sheet[2, 2] = 100 eq_(sheet.array, expected)
def test_random_access(): test_content = [[1, 2]] sheet = Sheet(test_content) eq_(sheet.to_array(), test_content) expected = dedent(""" pyexcel sheet: +---+-----+ | 1 | 100 | +---+-----+""").strip('\n') sheet[0, 1] = 100 eq_(str(sheet), expected)
def test_named_sheet_access(): test_content = [['A', 'B'], [1, 2]] sheet = Sheet(test_content, name_columns_by_row=0) eq_(sheet.to_array(), test_content) expected = dedent(""" pyexcel sheet: +-----+---+ | A | B | +=====+===+ | 100 | 2 | +-----+---+""").strip('\n') sheet[0, 'A'] = 100 print(str(sheet)) eq_(str(sheet), expected)
def test_random_access_to_unknown_area(): test_content = [[1, 2]] sheet = Sheet(test_content) eq_(sheet.to_array(), test_content) expected = dedent(""" pyexcel sheet: +---+---+-----+ | 1 | 2 | | +---+---+-----+ +---+---+-----+ | | | 100 | +---+---+-----+""").strip('\n') sheet[2, 2] = 100 eq_(str(sheet), expected)
def test_data_frame_access(): test_content = [['', 'A', 'B'], ['R', 1, 2]] sheet = Sheet(copy.deepcopy(test_content), name_columns_by_row=0, name_rows_by_column=0) eq_(sheet.to_array(), test_content) expected = dedent(""" pyexcel sheet: +---+-----+---+ | | A | B | +===+=====+===+ | R | 100 | 2 | +---+-----+---+""").strip('\n') sheet['R', 'A'] = 100 print(str(sheet)) eq_(str(sheet), expected)