def group(self, start, end=None, outline_level=1, hidden=False):
"""allow grouping a range of consecutive columns together
:param start: first column to be grouped (mandatory)
:param end: last column to be grouped (optional, default to start)
:param outline_level: outline level
:param hidden: should the group be hidden on workbook open or not
"""
if end is None:
end = start
if start in self:
new_dim = self.pop(start)
else:
new_dim = ColumnDimension(worksheet=self.worksheet, index=start)
work_sequence = get_column_interval(start, end)
for column_letter in work_sequence:
if column_letter in self:
del self[column_letter]
new_dim.min, new_dim.max = map(column_index_from_string, (start, end))
new_dim.outline_level = outline_level
new_dim.hidden = hidden
self[start] = new_dim
def group(self, start, end=None, outline_level=1, hidden=False):
"""allow grouping a range of consecutive columns together
:param start: first column to be grouped (mandatory)
:param end: last column to be grouped (optional, default to start)
:param outline_level: outline level
:param hidden: should the group be hidden on workbook open or not
"""
if end is None:
end = start
if start in self:
new_dim = self.pop(start)
else:
new_dim = ColumnDimension(index=start)
work_sequence = get_column_interval(start, end)
for column_letter in work_sequence:
if column_letter in self:
del self[column_letter]
new_dim.min, new_dim.max = map(column_index_from_string, (start, end))
new_dim.outline_level = outline_level
new_dim.hidden = hidden
self[start] = new_dim