src/Library/NetPro.Utility/Helpers/ExcelHelper.cs

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

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

using Microsoft.AspNetCore.Http;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System.Collections.Generic;
using System.Data;
using System.IO;

namespace System.NetPro
{
    public enum ExcelFormat
    {
        /// <summary>
        /// office2003的旧版格式.xls
        /// </summary>
        Xls = 2003,

        /// <summary>
        /// office2007的新版格式.xlsx
        /// </summary>
        Xlsx = 2007
    }

    /// <summary>
    /// 重写Npoi流方法
    /// </summary>
    public class NpoiMemoryStream : MemoryStream
    {
        public NpoiMemoryStream()
        {
            AllowClose = true;
        }

        public bool AllowClose { get; set; }

        public override void Close()
        {
            if (AllowClose)
                base.Close();
        }
    }

    /// <summary>
    /// Excel文件帮助类，通过NPOI进行操作
    /// </summary>
    public static class ExcelHelper
    {
        /// <summary>
        /// 读取Excel到DataTable(NPOI方式)
        /// </summary>
        /// <param name="fullFilePath">文件的完整物理路径</param>
        /// <returns>DataTable</returns>
        public static DataTable ReadExcelToTable(string fullFilePath)
        {
            IWorkbook wk = null;
            using (FileStream file = new FileStream(fullFilePath, FileMode.Open, FileAccess.Read))
            {
                string fileExtension = Path.GetExtension(file.Name)?.ToLower();
                switch (fileExtension)
                {