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 = NamedRange("test_nr", [(new_sheet, "A1")]) wb.add_named_range(named_range) named_ranges_list = wb.get_named_ranges() assert named_range in named_ranges_list
def test_add_named_range(): wb = Workbook() new_sheet = wb.create_sheet() named_range = NamedRange('test_nr', [(new_sheet, 'A1')]) wb.add_named_range(named_range) named_ranges_list = wb.get_named_ranges() assert named_range in named_ranges_list
def test_remove_named_range(): wb = Workbook() new_sheet = wb.create_sheet() named_range = NamedRange('test_nr', [(new_sheet, 'A1')]) wb.add_named_range(named_range) wb.remove_named_range(named_range) named_ranges_list = wb.get_named_ranges() assert named_range 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_print_titles(): wb = Workbook() ws1 = wb.create_sheet() ws2 = wb.create_sheet() ws1.add_print_title(2) ws2.add_print_title(3, rows_or_cols='cols') def mystr(nr): return ','.join(['%s!%s' % (sheet.title, name) for sheet, name in nr.destinations]) actual_named_ranges = set([(nr.name, nr.scope, mystr(nr)) for nr in wb.get_named_ranges()]) expected_named_ranges = set([('_xlnm.Print_Titles', ws1, 'Sheet1!$1:$2'), ('_xlnm.Print_Titles', ws2, 'Sheet2!$A:$C')]) assert(actual_named_ranges == expected_named_ranges)
def test_get_named_ranges(): wb = Workbook() eq_(wb.get_named_ranges(), wb._named_ranges)
def test_get_named_ranges(): wb = Workbook() assert wb.get_named_ranges() == wb._named_ranges
def test_get_named_ranges(): wb = Workbook() assert wb.get_named_ranges() == wb.defined_names.definedName