使用c#和Epplus将excel信息创建到数据表和数据集中

using OfficeOpenXml;
using System.IO;

private static DataTable ReadExcelToDataTable(string filePath)
{
    using (var package = new ExcelPackage(new FileInfo(filePath)))
    {
        var worksheet = package.Workbook.Worksheets[0];
        var table = new DataTable();
        
        for (int row = 1; row <= worksheet.Dimension.End.Row; row++)
        {
            if (row == 1)
            {
                // 读取表头
                for (int col = 1; col <= worksheet.Dimension.End.Column; col++)
                {
                    table.Columns.Add(worksheet.Cells[row, col].Value.ToString());
                }
            }
            else
            {
                // 读取数据行
                var dataRow = table.NewRow();
                for (int col = 1; col <= worksheet.Dimension.End.Column; col++)
                {
                    dataRow[col - 1] = worksheet.Cells[row, col].Value;
                }
                table.Rows.Add(dataRow);
            }
        }
        
        return table;
    }
}

string excelFilePath = "路径/文件名.xlsx";
DataTable dataTable = ReadExcelToDataTable(excelFilePath);

DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);