def add_conditional_format(self, start_row, end_row, start_col, end_col, min): cols = common.number_to_cells([start_col, end_col - 1]) self.conditional_formats[cols[0] + str(start_row + 1) + ":" + cols[1] + str(end_row + 1)] = { 'type': 'cell', 'criteria': 'between', 'minimum': 1, 'maximum': min + 10, 'format': 'cond_format' }
def merge(cell_str): nums = [int(n) for n in cell_str.split(",")] col = nums[1] row = nums[0] columns = common.number_to_cells([col, col + 3]) return columns[0] + str(row + 1) + ":" + columns[1] + str(row + 1)