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_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"