def test_cell_range_name(self): ws = Worksheet(self.wb) self.wb.create_named_range('test_range_single', ws, 'B12') c_range_name = ws.get_named_range('test_range_single') c_range_coord = tuple(tuple(ws.iter_rows('B12'))[0]) c_cell = ws.cell('B12') assert c_range_coord == (c_cell, ) assert c_range_name == (c_cell, )
def test_get_named_range(self): ws = Worksheet(self.wb) self.wb.create_named_range('test_range', ws, 'C5') xlrange = tuple(ws.get_named_range('test_range')) cell = xlrange[0] assert isinstance(cell, Cell) assert cell.row == 5
def test_get_named_range(self): ws = Worksheet(self.wb) self.wb.create_named_range('test_range', ws, 'C5') xlrange = tuple(ws.get_named_range('test_range')) cell = xlrange[0] assert isinstance(cell, Cell) assert cell.row == 5
def test_cell_range_name(self): ws = Worksheet(self.wb) self.wb.create_named_range('test_range_single', ws, 'B12') c_range_name = ws.get_named_range('test_range_single') c_range_coord = tuple(tuple(ws.iter_rows('B12'))[0]) c_cell = ws.cell('B12') assert c_range_coord == (c_cell,) assert c_range_name == (c_cell,)
def test_get_named_range_wrong_sheet(self): ws1 = Worksheet(self.wb) ws2 = Worksheet(self.wb) self.wb.create_named_range('wrong_sheet_range', ws1, 'C5') with pytest.raises(NamedRangeException): ws2.get_named_range('wrong_sheet_range')
def test_get_bad_named_range(self): ws = Worksheet(self.wb) with pytest.raises(NamedRangeException): ws.get_named_range('bad_range')
def test_get_named_range_wrong_sheet(self): ws1 = Worksheet(self.wb) ws2 = Worksheet(self.wb) self.wb.create_named_range('wrong_sheet_range', ws1, 'C5') with pytest.raises(NamedRangeException): ws2.get_named_range('wrong_sheet_range')
def test_get_bad_named_range(self): ws = Worksheet(self.wb) with pytest.raises(NamedRangeException): ws.get_named_range('bad_range')