def test_get_named_range_wrong_sheet(self, Worksheet):
wb = Workbook()
ws1 = wb.create_sheet("Sheet1")
ws2 = wb.create_sheet("Sheet2")
wb.create_named_range('wrong_sheet_range', ws1, 'C5')
with pytest.raises(NamedRangeException):
ws2.get_named_range('wrong_sheet_range')
def test_get_named_range_wrong_sheet(self, Worksheet):
wb = Workbook()
ws1 = Worksheet(wb)
ws2 = Worksheet(wb)
wb.create_named_range('wrong_sheet_range', ws1, 'C5')
with pytest.raises(NamedRangeException):
ws2.get_named_range('wrong_sheet_range')
def test_cell_range_name(self):
wb = Workbook()
ws = wb.active
wb.create_named_range('test_range_single', ws, 'B12')
c_range_name = ws.get_named_range('test_range_single')
c_cell = ws['B12']
assert c_range_name == (c_cell,)
def test_remove_named_range():
wb = Workbook()
new_sheet = wb.create_sheet()
wb.create_named_range('test_nr', new_sheet, 'A1')
del wb.defined_names['test_nr']
named_ranges_list = wb.get_named_ranges()
assert 'test_nr' not in named_ranges_list
def test_get_named_range(self, Worksheet):
wb = Workbook()
ws = Worksheet(wb)
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, Worksheet):
wb = Workbook()
ws = wb.active
wb.create_named_range('test_range', ws, value='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, Worksheet):
wb = Workbook()
ws = Worksheet(wb)
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_cell_range_name(self, Worksheet):
wb = Workbook()
ws = Worksheet(wb)
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_remove_sheet_with_names():
wb = Workbook()
new_sheet = wb.create_sheet()
wb.create_named_range('test_nr', new_sheet, 'A1', 1)
del wb['Sheet1']
assert wb.defined_names.definedName == []
def test_get_named_range():
wb = Workbook()
new_sheet = wb.create_sheet()
wb.create_named_range('test_nr', new_sheet, 'A1')
assert wb.defined_names['test_nr'].value == 'Sheet1!A1'
