def test_cell_range_name(self):
ws = Worksheet(self.wb)
self.wb.create_named_range('test_range_single', ws, 'B12')
assert_raises(CellCoordinatesException, ws.cell, 'test_range_single')
c_range_name = ws.range('test_range_single')
c_range_coord = ws.range('B12')
c_cell = ws.cell('B12')
eq_(c_range_coord, c_range_name)
eq_(c_range_coord, c_cell)
def test_cell_range_name(self):
ws = Worksheet(self.wb)
self.wb.create_named_range('test_range_single', ws, 'B12')
assert_raises(CellCoordinatesException, ws.cell, 'test_range_single')
c_range_name = ws.range('test_range_single')
c_range_coord = ws.range('B12')
c_cell = ws.cell('B12')
eq_(c_range_coord, c_range_name)
eq_(c_range_coord, c_cell)
def test_cell_range_name(self):
ws = Worksheet(self.wb)
self.wb.create_named_range('test_range_single', ws, 'B12')
with pytest.raises(CellCoordinatesException):
ws.cell('test_range_single')
c_range_name = ws.range('test_range_single')
c_range_coord = ws.range('B12')
c_cell = ws.cell('B12')
assert c_range_coord == c_range_name
assert c_range_coord == c_cell
def test_cell_range_name(self):
ws = Worksheet(self.wb)
self.wb.create_named_range('test_range_single', ws, 'B12')
with pytest.raises(CellCoordinatesException):
ws.cell('test_range_single')
c_range_name = ws.range('test_range_single')
c_range_coord = ws.range('B12')
c_cell = ws.cell('B12')
assert c_range_coord == c_range_name
assert c_range_coord == c_cell
def test_range_offset(self):
ws = Worksheet(self.wb)
xlrange = ws.range('A1:C4', 1, 3)
assert isinstance(xlrange, tuple)
eq_(4, len(xlrange))
eq_(3, len(xlrange[0]))
eq_('D2', xlrange[0][0].get_coordinate())
def test_range_offset(self):
ws = Worksheet(self.wb)
xlrange = ws.range('A1:C4', 1, 3)
assert isinstance(xlrange, tuple)
assert 4 == len(xlrange)
assert 3 == len(xlrange[0])
assert 'D2' == xlrange[0][0].get_coordinate()
def test_range_offset(self):
ws = Worksheet(self.wb)
xlrange = ws.range('A1:C4', 1, 3)
assert isinstance(xlrange, tuple)
eq_(4, len(xlrange))
eq_(3, len(xlrange[0]))
eq_('D2', xlrange[0][0].get_coordinate())
def test_range_offset(self):
ws = Worksheet(self.wb)
xlrange = ws.range('A1:C4', 1, 3)
assert isinstance(xlrange, tuple)
assert 4 == len(xlrange)
assert 3 == len(xlrange[0])
assert 'D2' == xlrange[0][0].coordinate
def test_auto_filter(self):
ws = Worksheet(self.wb)
ws.auto_filter = ws.range('a1:f1')
assert ws.auto_filter == 'A1:F1'
ws.auto_filter = ''
assert ws.auto_filter is None
ws.auto_filter = 'c1:g9'
assert ws.auto_filter == 'C1:G9'
def test_auto_filter(self):
ws = Worksheet(self.wb)
ws.auto_filter = ws.range('a1:f1')
assert ws.auto_filter == 'A1:F1'
ws.auto_filter = ''
assert ws.auto_filter is None
ws.auto_filter = 'c1:g9'
assert ws.auto_filter == 'C1:G9'
def test_append_2d_list(self):
ws = Worksheet(self.wb)
ws.append(['This is A1', 'This is B1'])
ws.append(['This is A2', 'This is B2'])
vals = ws.range('A1:B2')
eq_((('This is A1', 'This is B1'),
('This is A2', 'This is B2'),), flatten(vals))
def test_append_2d_list(self):
ws = Worksheet(self.wb)
ws.append(['This is A1', 'This is B1'])
ws.append(['This is A2', 'This is B2'])
vals = ws.range('A1:B2')
eq_((('This is A1', 'This is B1'),
('This is A2', 'This is B2'),), flatten(vals))
def test_append_2d_list(self):
ws = Worksheet(self.wb)
ws.append(['This is A1', 'This is B1'])
ws.append(['This is A2', 'This is B2'])
vals = ws.range('A1:B2')
expected = (
('This is A1', 'This is B1'),
('This is A2', 'This is B2'),
)
for e, v in zip(expected, flatten(vals)):
assert e == tuple(v)
def test_append_2d_list(self):
ws = Worksheet(self.wb)
ws.append(['This is A1', 'This is B1'])
ws.append(['This is A2', 'This is B2'])
vals = ws.range('A1:B2')
expected = (
('This is A1', 'This is B1'),
('This is A2', 'This is B2'),
)
for e, v in zip(expected, flatten(vals)):
assert e == tuple(v)
def test_worksheet_named_range(self):
ws = Worksheet(self.wb)
self.wb.create_named_range('test_range', ws, 'C5')
xlrange = ws.range('test_range')
assert isinstance(xlrange, Cell)
eq_(5, xlrange.row)
def test_worksheet_range(self):
ws = Worksheet(self.wb)
xlrange = ws.range('A1:C4')
assert isinstance(xlrange, tuple)
eq_(4, len(xlrange))
eq_(3, len(xlrange[0]))
def test_bad_named_range(self):
ws = Worksheet(self.wb)
with pytest.raises(NamedRangeException):
ws.range('bad_range')
def test_named_range_wrong_sheet(self):
ws1 = Worksheet(self.wb)
ws2 = Worksheet(self.wb)
self.wb.create_named_range('wrong_sheet_range', ws1, 'C5')
with pytest.raises(NamedRangeException):
ws2.range('wrong_sheet_range')
def test_worksheet(self, recwarn):
ws = Worksheet(self.wb)
rows = ws.range("A1:D4")
w = recwarn.pop()
assert issubclass(w.category, UserWarning)
def test_named_range_wrong_sheet(self):
ws1 = Worksheet(self.wb)
ws2 = Worksheet(self.wb)
self.wb.create_named_range('wrong_sheet_range', ws1, 'C5')
with pytest.raises(NamedRangeException):
ws2.range('wrong_sheet_range')
def test_bad_named_range(self):
ws = Worksheet(self.wb)
ws.range('bad_range')
def test_worksheet_named_range(self):
ws = Worksheet(self.wb)
self.wb.create_named_range('test_range', ws, 'C5')
xlrange = ws.range('test_range')
assert isinstance(xlrange, Cell)
eq_(5, xlrange.row)
def test_worksheet_range(self):
ws = Worksheet(self.wb)
xlrange = ws.range('A1:C4')
assert isinstance(xlrange, tuple)
eq_(4, len(xlrange))
eq_(3, len(xlrange[0]))
def test_worksheet(self, recwarn):
ws = Worksheet(self.wb)
rows = ws.range("A1:D4")
w = recwarn.pop()
assert issubclass(w.category, UserWarning)
def test_bad_named_range(self):
ws = Worksheet(self.wb)
with pytest.raises(NamedRangeException):
ws.range('bad_range')
def test_bad_named_range(self):
ws = Worksheet(self.wb)
ws.range('bad_range')
def test_named_range_wrong_sheet(self):
ws1 = Worksheet(self.wb)
ws2 = Worksheet(self.wb)
self.wb.create_named_range('wrong_sheet_range', ws1, 'C5')
ws2.range('wrong_sheet_range')
def test_named_range_wrong_sheet(self):
ws1 = Worksheet(self.wb)
ws2 = Worksheet(self.wb)
self.wb.create_named_range('wrong_sheet_range', ws1, 'C5')
ws2.range('wrong_sheet_range')
