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)