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'])