def test_add_vals_row(self):
ws = Workbook().active
ws.append(("head1", "head2", "head3"))
ws.append(("vals", "morevals", "allthevals"))
r = etl.add_vals(ws, ['new', 'header'], 'D1', 'r')
rh = etl.get_values(r.rows[0])
self.assertEqual(rh, ['head1', 'head2', 'head3', 'new', 'header'])
def test_add_vals_row(self):
ws = Workbook().active
ws.append(("head1", "head2", "head3"))
ws.append(("vals", "morevals", "allthevals"))
r = etl.add_vals(ws, ['new','header'], 'D1','r')
rh = etl.get_values(r.rows[0])
self.assertEqual(rh, ['head1', 'head2', 'head3', 'new','header'])
def test_add_vals_col(self):
ws = Workbook().active
r = etl.add_vals(ws, ['new', 'vals'], 'B1', 'c')
rh = etl.get_values(r.columns[1])
self.assertEqual(rh, ['new', 'vals'])
def test_add_vals_col(self):
ws = Workbook().active
r = etl.add_vals(ws, ['new','vals'], 'B1','c')
rh = etl.get_values(r.columns[1])
self.assertEqual(rh, ['new','vals'])