public static DataSet ReadExcelToDataSet(string filePath, string sheetName)
{
DataSet ds = new DataSet();
DataRow dr;
object objCellValue;
string cellValue;
using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.ReadWrite))
{
EPPlus 5.0 以后的版本需要指定 商业证书 或者非商业证书
//ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (ExcelPackage package = new ExcelPackage())
{
package.Load(fs);
foreach (var sheet in package.Workbook.Worksheets)
{
if (sheet.Name.ToUpper().Trim() == sheetName.ToUpper().Trim())
{
#region