/// <summary>

        /// 合并列

        /// </summary>

        /// <param name="sheet"></param>

        /// <param name="startRowIndex"></param>

        /// <param name="items"></param>

        /// <param name="propertySelectors"></param>

        /// <param name="compareColIndex">比较的列</param>

        /// <param name="mergeColIndex">合并的列集合</param>

        public static void MergeColCells(ExcelWorksheet sheet, int startRowIndex, IList<Student> items, Func<Student, object>[] propertySelectors, int compareColIndex,List<int> mergeColIndexs)

        {

            Dictionary<int, int> dicMerge = new Dictionary<int, int>();

            var preData = string.Empty;

            int index = ;

            for (var i = ; i < items.Count; i++)

            {

                var currData = propertySelectors[compareColIndex](items[i]);

                if (string.IsNullOrEmpty(preData) || currData.ToString() != preData)

                {

                    preData = currData.ToString();

                    dicMerge.Add(i, i);

                    index = i;

                }

                else

                {

                    dicMerge[index] = i;

                }

                for (var j = ; j < propertySelectors.Length; j++)

                {

                    var colData = propertySelectors[j](items[i]);

                    sheet.Cells[i + startRowIndex, j + ].Value = colData;

                }

            }

            foreach (var item in dicMerge)

            {

                if (item.Value - item.Key > )

                {

                    for (int i = ; i < mergeColIndexs.Count; i++)

                    {

                        sheet.Cells[item.Key + startRowIndex, mergeColIndexs[i] + , item.Value + startRowIndex, mergeColIndexs[i] + ].Merge = true;

                        sheet.Cells[item.Key + startRowIndex, mergeColIndexs[i] + , item.Value + startRowIndex, mergeColIndexs[i] + ].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;

                        sheet.Cells[item.Key + startRowIndex, mergeColIndexs[i] + , item.Value + startRowIndex, mergeColIndexs[i] + ].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;

                    }

                }

            }

        }

 List<int> mergeColIndexs = new List<int>();

                mergeColIndexs.Add();

                mergeColIndexs.Add();

                EpplusHelper.MergeColCells(worksheet,,studentList,columnsValueList.ToArray(),, mergeColIndexs);