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 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)
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)
