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)