private void GroupOfferColumns()
{
ProjectWorkbook projectWorkbook = new ProjectWorkbook();
foreach (OfferColumns address in projectWorkbook.OfferColumns)
{
Excel.Range rngCoulumn = SheetAnalysis.Range[SheetAnalysis.Cells[1, address.ColStartOffer + 1], SheetAnalysis.Cells[1, address.ColCostTotalOffer - 1]];
rngCoulumn.Columns.Group();
}
}
/// <summary>
/// Группировать столбцы
/// </summary>
public void GroupColumn()
{
ExcelHelper.UnGroupColumns(SheetAnalysis);
GroupColumnsBasis();
GroupOfferColumns();
List <OfferColumns> addresslist = new ProjectWorkbook().GetOfferColumns();
foreach (OfferColumns address in addresslist)
{
GroupCommetnsColumns(address);
}
}
