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