EPPlus 合并单元格

        /// <summary>
        /// 功能描述: 合并行单元格
        /// </summary>
        /// <param name="sheet">Excel页</param>
        /// <param name="mergeColIndexs">合并起始行</param>
        /// <param name="startColIndex">合并列</param>
        /// <param name="mergeNumber">需要合并的行数</param>
        public static void MergeColCells(ExcelWorksheet sheet, Dictionary<int, int> dicMerge, int startColIndex)
        {
            foreach (var item in dicMerge)
            {
                sheet.Cells[item.Key, startColIndex, item.Value, startColIndex].Merge = true;
                sheet.Cells[item.Key, startColIndex, item.Value, startColIndex].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
                sheet.Cells[item.Key, startColIndex, item.Value, startColIndex].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
            }
        }

注意：本文归作者所有，未经作者允许，不得转载