需引用ExcelDataReader、ExcelDataReader.DataSet、EPPlus
using System;
using System.IO;
using ExcelDataReader;
using OfficeOpenXml;
using LicenseContext = OfficeOpenXml.LicenseContext;
LicenseContext licenseContext = new LicenseContext();
ExcelPackage.LicenseContext = licenseContext;
using (var stream = File.Open(Excel文件路径, FileMode.Open, FileAccess.Read))
{
string filename=Path.GetFileName(Excel文件路径);
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
// 读取第一个工作表
&nbs