NetQuickJamesFrame/Util/File_EXCELHelper.cs

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

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

using OfficeOpenXml;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;

namespace NetQuickJamesFrame.Util
{
    public class File_EXCELHelper
    {
        public DataTable readExcel_usingEPPlus(string filePath, int sheetNumber)
        {
            DataTable dt = new DataTable();

            var fileInfo = new FileInfo(filePath);
            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
            using (var package = new ExcelPackage(fileInfo))
            {
                var worksheet = package.Workbook.Worksheets[sheetNumber];

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

                for (int col = 1; col <= worksheet.Dimension.Columns; col++)
                {
                    string title = isNull(worksheet.Cells[1, col].Value).ToString();
                    if (title.Trim() != "")
                    {
                        dt.Columns.Add(title);
                        validColList.Add(col);
                    }
                }


                for (int row = 2; row <= worksheet.Dimension.Rows; row++)
                {
                    DataRow dr = dt.NewRow();

                    for (int drCol = 0; drCol < validColList.Count; drCol++)
                    {
                        dr[drCol] = isNull(worksheet.Cells[row, validColList[drCol]].Value).ToString();
                    }

                    dt.Rows.Add(dr);
                }
            }

            return dt;
        }

        private string isNull(object obj)
        {
            return (obj == null) ? "" : obj.ToString();
        }

        public bool writeExcel_usingEPPlus(string filePath, string sheetName, DataTable dt)
        {
            try
            {