def test_set_active_by_index(): wb = Workbook() names = [ 'Sheet', 'Sheet1', 'Sheet2', ] for n in names: wb.create_sheet(n) for idx, name in enumerate(names): wb.active = idx assert wb.active == wb.worksheets[idx]
def test_set_active_by_sheet(): wb = Workbook() names = [ 'Sheet', 'Sheet1', 'Sheet2', ] for n in names: wb.create_sheet(n) for n in names: sheet = wb[n] wb.active = sheet assert wb.active == wb[n]
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_set_hidden_sheet_as_active(): wb = Workbook() ws = wb.create_sheet() ws.sheet_state = 'hidden' with pytest.raises(ValueError): wb.active = ws
def test_cannot_copy_writeonly(self): wb = Workbook(write_only=True) ws = wb.create_sheet() with pytest.raises(ValueError): wb.copy_worksheet(ws)
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"
def test_index(): wb = Workbook() new_sheet = wb.create_sheet() sheet_index = wb.index(new_sheet) assert sheet_index == 1
def test_get_sheet_names(): wb = Workbook() names = ['Sheet', 'Sheet1', 'Sheet2', 'Sheet3', 'Sheet4', 'Sheet5'] for count in range(5): wb.create_sheet(0) assert wb.sheetnames == names
def test_remove_sheet(): wb = Workbook() new_sheet = wb.create_sheet(0) wb.remove(new_sheet) assert new_sheet not in wb.worksheets
def test_create_sheet_readonly(): wb = Workbook() wb._read_only = True with pytest.raises(ReadOnlyWorkbookException): wb.create_sheet()
def test_add_correct_sheet(): wb = Workbook() new_sheet = wb.create_sheet() wb._add_sheet(new_sheet) assert new_sheet == wb.worksheets[2]
def test_create_sheet_with_name(): wb = Workbook() new_sheet = wb.create_sheet(title='LikeThisName') assert new_sheet == wb.worksheets[-1]
def test_create_sheet(): wb = Workbook() new_sheet = wb.create_sheet() assert new_sheet == wb.worksheets[-1]