def test_groups2(self):
wb = pyxl.Workbook()
ws = wb.active
header = ('Ref', 'x', 'y', 'z')
ws.append(header)
ws.append(('C1', '1', '1', '1'))
ws.append(('R3', '2', '1', '1'))
ws.append(('R5', '2', '1', '1'))
ws.append(('X1', '3', '1', '1'))
ws.append(('X2', '1', '3', '1'))
ws.append(('X3', '1', '1', '3'))
wb = kifield.group_wb(wb)
ws = wb.active
assert ws.max_row == 6
assert ws.max_column == 4
values = tuple(ws.values)
assert values[0] == header
assert values[1] == ('C1', '1', '1', '1')
assert values[2] == ('R3, R5', '2', '1', '1')
assert values[3] == ('X1', '3', '1', '1')
assert values[4] == ('X2', '1', '3', '1')
assert values[5] == ('X3', '1', '1', '3')
评论列表
文章目录