def test_cell_range_name(self):
wb = Workbook()
ws = wb.active
wb.create_named_range('test_range_single', ws, 'B12')
c_range_name = ws.get_named_range('test_range_single')
c_cell = ws['B12']
assert c_range_name == (c_cell, )
def test_get_named_range_wrong_sheet(self, Worksheet):
wb = Workbook()
ws1 = wb.create_sheet("Sheet1")
ws2 = wb.create_sheet("Sheet2")
wb.create_named_range('wrong_sheet_range', ws1, 'C5')
with pytest.raises(NamedRangeException):
ws2.get_named_range('wrong_sheet_range')
def test_get_named_range(self, Worksheet):
wb = Workbook()
ws = wb.active
wb.create_named_range('test_range', ws, value='C5')
xlrange = tuple(ws.get_named_range('test_range'))
cell = xlrange[0]
assert isinstance(cell, Cell)
assert cell.row == 5
def test_append_dict_index(self, Worksheet):
ws = Worksheet(Workbook())
ws.append({1: 'This is A1', 3: 'This is C1'})
assert 'This is A1' == ws['A1'].value
assert 'This is C1' == ws['C1'].value
def test_append_dict_letter(self, Worksheet):
ws = Worksheet(Workbook())
ws.append({'A': 'This is A1', 'C': 'This is C1'})
assert 'This is A1' == ws['A1'].value
assert 'This is C1' == ws['C1'].value
def test_append_list(self, Worksheet):
ws = Worksheet(Workbook())
ws.append(['This is A1', 'This is B1'])
assert 'This is A1' == ws['A1'].value
assert 'This is B1' == ws['B1'].value
def test_append_iterator(self, Worksheet):
def itty():
for i in range(30):
yield i
ws = Worksheet(Workbook())
gen = itty()
ws.append(gen)
assert ws['AD1'].value == 29
def test_append_cell(self, Worksheet):
from openpyxl25.cell.cell import Cell
cell = Cell(None, 'A', 1, 25)
ws = Worksheet(Workbook())
ws.append([])
ws.append([cell])
assert ws['A2'].value == 25
def test_append_2d_list(self, Worksheet):
ws = Worksheet(Workbook())
ws.append(['This is A1', 'This is B1'])
ws.append(['This is A2', 'This is B2'])
vals = ws.iter_rows(min_row=1, min_col=1, max_row=2, max_col=2)
expected = (
('This is A1', 'This is B1'),
('This is A2', 'This is B2'),
)
for e, v in zip(expected, ws.values):
assert e == tuple(v)
def test_rows(self, Worksheet):
ws = Worksheet(Workbook())
ws['A1'] = 'first'
ws['C9'] = 'last'
rows = tuple(ws.rows)
assert len(rows) == 9
first_row = rows[0]
last_row = rows[-1]
assert first_row[0].value == 'first' and first_row[0].coordinate == 'A1'
assert last_row[-1].value == 'last'
def test_cols(self, Worksheet):
ws = Worksheet(Workbook())
ws['A1'] = 'first'
ws['C9'] = 'last'
expected = [
('A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9'),
('B1', 'B2', 'B3', 'B4', 'B5', 'B6', 'B7', 'B8', 'B9'),
('C1', 'C2', 'C3', 'C4', 'C5', 'C6', 'C7', 'C8', 'C9'),
]
cols = tuple(ws.columns)
for col, coord in zip(cols, expected):
assert tuple(c.coordinate for c in col) == coord
assert len(cols) == 3
assert cols[0][0].value == 'first'
assert cols[-1][-1].value == 'last'