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]