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_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_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') 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_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_bad_named_range(self): ws = Worksheet(self.wb) ws.range('bad_range')