def _next_col(crange):
sr = crange.split(":")
if len(sr) == 1:
m = cell2tuple(crange)
result = col2abc(abc2col(m[0]) + 1) + m[1]
else:
hm = cell2tuple(sr[0])
tm = cell2tuple(sr[1])
head = col2abc(abc2col(tm[0]) + 1) + hm[1]
tail = col2abc(2 * abc2col(tm[0]) - abc2col(hm[0]) + 1) + tm[1]
result = ":".join([head, tail])
return result
def set_cell(self, cell_range, value):
tm = xlutils.cell2tuple(cell_range)
col = xlutils.abc2col(tm[0])
row = tm[1]
self._sheet.set_cell(row, col, value)
