def test_VLOOOKUP_with_oversized_col_index_num(self):
# Excel Doc example.
range1 = xltypes.Array([
[101, 'Davis', 'Sara'],
])
self.assertIsInstance(lookup.VLOOKUP(102, range1, 4, False),
xlerrors.ValueExcelError)
def test_VLOOOKUP(self):
# Excel Doc example.
range1 = xltypes.Array([
[101, 'Davis', 'Sara'],
[102, 'Fortana', 'Olivier'],
[103, 'Leal', 'Karina'],
[104, 'Patten', 'Michael'],
[105, 'Burke', 'Brian'],
[106, 'Sousa', 'Luis'],
])
self.assertEqual(lookup.VLOOKUP(102, range1, 2, False), 'Fortana')
def test_VLOOOKUP_with_unknown_lookup_value(self):
range1 = xltypes.Array([
[101, 'Davis', 'Sara'],
])
self.assertIsInstance(lookup.VLOOKUP(102, range1, 2, False),
xlerrors.NaExcelError)
def test_VLOOOKUP_with_range_lookup(self):
with self.assertRaises(NotImplementedError):
lookup.VLOOKUP(1, xltypes.Array([[]]), 2, True)
def test_VLOOOKUP_with_range_lookup(self):
with self.assertRaises(NotImplementedError):
lookup.VLOOKUP(1, xl.RangeData(), 2, True)