/usr/lib/python2.7/dist-packages/openpyxl/utils/tests/test_cell.py is in python-openpyxl 2.4.9-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 | from __future__ import absolute_import
# Copyright (c) 2010-2017 openpyxl
import pytest
from .. import (
column_index_from_string,
coordinate_from_string,
get_column_letter,
absolute_coordinate,
get_column_interval,
)
def test_coordinates():
assert coordinate_from_string('ZF46') == ("ZF", 46)
@pytest.mark.parametrize("value", ['AAA', "AQ0"])
def test_invalid_coordinate(value):
from ..exceptions import CellCoordinatesException
with pytest.raises(CellCoordinatesException):
coordinate_from_string(value)
@pytest.mark.parametrize("coord, result",
[
("ZF51",'$ZF$51',),
('ZF51:ZF53', '$ZF$51:$ZF$53'),
("A:G", "$A:$G"),
("A", "$A"),
("1", "$1"),
]
)
def test_absolute(coord, result):
assert absolute_coordinate(coord) == result
def test_column_interval():
expected = ['A', 'B', 'C', 'D']
assert get_column_interval('A', 'D') == expected
assert get_column_interval('A', 4) == expected
@pytest.mark.parametrize("column, idx",
[
('j', 10),
('Jj', 270),
('JJj', 7030),
('A', 1),
('Z', 26),
('AA', 27),
('AZ', 52),
('BA', 53),
('BZ', 78),
('ZA', 677),
('ZZ', 702),
('AAA', 703),
('AAZ', 728),
('ABC', 731),
('AZA', 1353),
('ZZA', 18253),
('ZZZ', 18278),
]
)
def test_column_index(column, idx):
assert column_index_from_string(column) == idx
@pytest.mark.parametrize("column",
('JJJJ', '', '$', '1',)
)
def test_bad_column_index(column):
with pytest.raises(ValueError):
column_index_from_string(column)
@pytest.mark.parametrize("value", (0, 18729))
def test_column_letter_boundries(value):
with pytest.raises(ValueError):
get_column_letter(value)
@pytest.mark.parametrize("value, expected",
[
(18278, "ZZZ"),
(7030, "JJJ"),
(28, "AB"),
(27, "AA"),
(26, "Z")
]
)
def test_column_letter(value, expected):
assert get_column_letter(value) == expected
def test_coordinate_tuple():
from .. import coordinate_to_tuple
assert coordinate_to_tuple("D15") == (15, 4)
@pytest.mark.parametrize("range_string, sheetname, boundaries",
[
("Sheet1!$A$1:$A$12", "Sheet1", (1,1, 1,12)),
("'My Sheet'!A1:E6", "My Sheet", (1,1, 5,6)),
]
)
def test_range_to_tuple(range_string, sheetname, boundaries):
from .. import range_to_tuple
assert range_to_tuple(range_string) == (sheetname, boundaries)
def test_invalid_range():
from .. import range_to_tuple
with pytest.raises(ValueError):
range_to_tuple("A1:E5")
@pytest.mark.parametrize("title, quoted",
[
(u'In D\xfcsseldorf', u"'In D\xfcsseldorf'"),
(u'My-Sheet', u"'My-Sheet'"),
(u"Demande d'autorisation", "'Demande d''autorisation'"),
(u"d'autorisation", "'d''autorisation'"),
]
)
def test_quote_sheetname(title, quoted):
from .. import quote_sheetname
assert quote_sheetname(title) == quoted
def test_rows_from_range():
from .. import rows_from_range
cells = rows_from_range("A1:D4")
cells = [list(row) for row in cells]
assert cells == [
['A1', 'B1', 'C1', 'D1'],
['A2', 'B2', 'C2', 'D2'],
['A3', 'B3', 'C3', 'D3'],
['A4', 'B4', 'C4', 'D4'],
]
def test_cols_from_range():
from .. import cols_from_range
cells = cols_from_range("A1:D4")
cells = [list(row) for row in cells]
assert cells == [
['A1', 'A2', 'A3', 'A4'],
['B1', 'B2', 'B3', 'B4'],
['C1', 'C2', 'C3', 'C4'],
['D1', 'D2', 'D3', 'D4'],
]
@pytest.mark.parametrize('range_string, coords',
[
('C1:C4', (3, 1, 3, 4)),
('C1', (3, 1, 3, 1)),
('D:F', (4, None, 6, None)),
('A', (1, None, 1, None)),
('1:10',(None, 1, None, 10)),
('1', (None, 1, None, 1)),
])
def test_bounds(range_string, coords):
from ..cell import range_boundaries
assert range_boundaries(range_string) == coords
def test_invalid_bounds():
from ..cell import range_boundaries
with pytest.raises(ValueError):
r = range_boundaries(":-1")
|