Shared/Kernelx.Excel2NPOI/NPOI/ExeclCmpter.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using NPOI.XSSF.UserModel;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

#if NET35
using Kernelx.ComponentModel.DataAnnotations;
#endif

#if NETSTANDARD2_0
using System.ComponentModel.DataAnnotations;
#endif

namespace Kernelx.Contexts.NPOI
{ 
    public class ExeclCmpter : IExeclCmpter
    {
        public DataSet ReadExeclFileStream(Stream stream, bool isXlsx, bool hasHeaderow)
        {
            IWorkbook workbook = isXlsx ? new XSSFWorkbook(stream) as IWorkbook : new HSSFWorkbook(stream);

            var items = workbook.GetEnumerator();
            var ds = new DataSet();
            while (items.MoveNext())
            {
                ISheet sheet = items.Current as ISheet;
                ds.Tables.Add(_Generate(sheet, hasHeaderow));
            }
            return ds;
        }


        [System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE1006:命名样式", Justification = "<挂起>")]
        private static DataTable _Generate(ISheet sheet, bool hasHeaderow)
        {
            var dt = new DataTable(sheet.SheetName);

            var firstrow = sheet.GetRow(0);
            var colCount = firstrow.LastCellNum;
            for (var i = 0; i < colCount; i++)
            {
                var colName = firstrow.GetCell(i)?.ToString();
                //没有行头或者空值时,使用默认头
                if (!hasHeaderow || string.IsNullOrEmpty(colName))
                    colName = $"column_{i}";

                dt.Columns.Add(new DataColumn(colName));
            }

            for (var i = (hasHeaderow ? 1 : 0); i <= sheet.LastRowNum; i++)
            {
                var row = sheet.GetRow(i);
                if (row == null || row.Cells.All(d => d.CellType == CellType.Blank)) continue;
                var rd = dt.NewRow();
                for (var ci = 0; ci < colCount; ci++)