IT俱乐部 ASP.NET .Net Core NPOI 导出多级表头的实现代码

.Net Core NPOI 导出多级表头的实现代码

发布: 2024年 12月 8日 394阅读

想要导出这样的表格

数据准备格式

附上源码

using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using System.Data;
using System.Text.RegularExpressions;
namespace TestConsoleApp
{
    /// <summary>
    /// 导出Excel
    /// </summary>
    public static class ExportHelper
    {
        public static void Export()
        {
            var dt = CreteTable();
            var titles = GetExcelTitles(dt.Columns, out int maxTitleLevel);
            HSSFWorkbook workbook = new HSSFWorkbook();
            ISheet sheet = workbook.CreateSheet("Sheet1");
            var allRowCount = dt.Rows.Count + maxTitleLevel;
            //创建所有单元格
            for (int i = 0; i  0)
                {
                    sheet.AddMergedRegion(new CellRangeAddress(tit.StartRow, tit.StartRow + tit.MergeRowCount, tit.StartColumn, tit.StartColumn + tit.MergeColumnCount));
                }
            }
            //生成数据行
            for (int i = 0; i  GetExcelTitles(DataColumnCollection columns, out int maxTitleLevel)
        {
            maxTitleLevel = 0;
            List levelExcelTitles = new List();
            for (var index = 0; index  new
                {
                    b.LevelCode,
                    b.Title
                })
               .Select(b => new ExcelTitle()
               {
                   Title = b.Key.Title,
                   StartRow = b.Min(c => c.RowIndex),
                   MergeRowCount = b.Min(c => c.RowIndex) + 1 == b.Max(c => c.TotalLevel) ? titleLevel - b.Max(c => c.TotalLevel) : 0,
                   StartColumn = b.Min(c => c.ColumnIndex),
                   MergeColumnCount = b.Count() - 1,//排除自身
               }).ToList();
            return excelTitles;
        }
    }
    public class ExcelTitle
    {
        /// <summary>
        /// 标题
        /// </summary>
        public string Title { get; set; }
        /// <summary>
        /// 开始行
        /// </summary>
        public int StartRow { get; set; }
        /// <summary>
        /// 合并行
        /// </summary>
        public int MergeRowCount { get; set; }
        /// <summary>
        /// 开始列
        /// </summary>
        public int StartColumn { get; set; }
        /// <summary>
        /// 合并列
        /// </summary>
        public int MergeColumnCount { get; set; }
    }
    public class LevelExcelTitle
    {
        /// <summary>
        /// 标题
        /// </summary>
        public string Title { get; set; }
        public string LevelCode { get; set; }
        /// <summary>
        /// 第几行
        /// </summary>
        public int RowIndex { get; set; }
        /// <summary>
        /// 第几列
        /// </summary>
        public int ColumnIndex { get; set; }
        /// <summary>
        /// 总层
        /// </summary>
        public int TotalLevel { get; set; }
    }
}

到此这篇关于.Net Core NPOI 导出多级表头的文章就介绍到这了,更多相关.Net Core NPOI 导出多级表头内容请搜索IT俱乐部以前的文章或继续浏览下面的相关文章希望大家以后多多支持IT俱乐部！

本文收集自网络，不代表IT俱乐部立场，转载请注明出处。https://www.2it.club/code/asp-net/14150.html

135赞

标签:core net npoi 多级表头