def test_invalid_cell(self, Worksheet): wb = Workbook() ws = Worksheet(wb) with pytest.raises(ValueError): cell = ws.cell(row=0, column=0)
def test_get_cell(self, Worksheet): ws = Worksheet(Workbook()) cell = ws.cell(row=1, column=1) assert cell.coordinate == 'A1'
def test_get_row(self, Worksheet, key): ws = Worksheet(Workbook()) a2 = ws.cell(row=2, column=1) b2 = ws.cell(row=2, column=2) c2 = ws.cell(row=2, column=3, value=5) assert ws[key] == (a2, b2, c2)
def test_get_single__column(self, Worksheet, key): ws = Worksheet(Workbook()) c1 = ws.cell(row=1, column=3) c2 = ws.cell(row=2, column=3, value=5) assert ws["C"] == (c1, c2)
def test_cell_insufficient_coordinates(self, Worksheet): ws = Worksheet(Workbook()) with pytest.raises(TypeError): ws.cell(row=8)
def test_cell_alternate_coordinates(self, Worksheet): ws = Worksheet(Workbook()) cell = ws.cell(row=8, column=4) assert 'D8' == cell.coordinate