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_add_named_range():
wb = Workbook()
new_sheet = wb.create_sheet()
named_range = DefinedName('test_nr')
named_range.value = "Sheet!A1"
wb.add_named_range(named_range)
named_ranges_list = wb.get_named_ranges()
assert named_range in named_ranges_list
def test_get_named_ranges():
wb = Workbook()
assert wb.get_named_ranges() == wb.defined_names.definedName