Exemplo n.º 1
0
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]
Exemplo n.º 2
0
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]
Exemplo n.º 3
0
def test_set_hidden_sheet_as_active():
    wb = Workbook()
    ws = wb.create_sheet()
    ws.sheet_state = 'hidden'
    with pytest.raises(ValueError):
        wb.active = ws
Exemplo n.º 4
0
def test_set_invalid_child_as_active():
    wb1 = Workbook()
    wb2 = Workbook()
    ws2 = wb2['Sheet']
    with pytest.raises(ValueError):
        wb1.active = ws2
Exemplo n.º 5
0
def test_set_invalid_sheet_by_name():
    wb = Workbook()
    with pytest.raises(TypeError):
        wb.active = "Sheet"
Exemplo n.º 6
0
def test_set_invalid_active_index():
    wb = Workbook()
    with pytest.raises(ValueError):
        wb.active = 1