def test_random_access_to_unknown_area():
test_content = [[1, 2]]
sheet = Sheet(copy.deepcopy(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_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_named_sheet_access():
test_content = [["A", "B"], [1, 2]]
sheet = Sheet(copy.deepcopy(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_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_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)
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)