def test_append_dict_letter(self): ws = Worksheet(self.wb) ws.append({'A': 'This is A1', 'C': 'This is C1'}) eq_('This is A1', ws.cell('A1').value) eq_('This is C1', ws.cell('C1').value)
def test_append_dict_index(self): ws = Worksheet(self.wb) ws.append({0: 'This is A1', 2: 'This is C1'}) eq_('This is A1', ws.cell('A1').value) eq_('This is C1', ws.cell('C1').value)
def test_append_list(self): ws = Worksheet(self.wb) ws.append(['This is A1', 'This is B1']) eq_('This is A1', ws.cell('A1').value) eq_('This is B1', ws.cell('B1').value)
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_bad_append(self): ws = Worksheet(self.wb) ws.append("test")