在ASP.NET Web应用程序中C#将数据从Excel传回Datagrid

using Microsoft.Office.Interop.Excel;

// 创建Excel应用程序对象
Application excelApp = new Application();

// 打开Excel文件
Workbook excelWorkbook = excelApp.Workbooks.Open("路径/文件名.xlsx");
Worksheet excelWorksheet = excelWorkbook.Sheets[1];

using System.Data;

// 创建DataTable对象
DataTable dt = new DataTable();

// 读取Excel中的数据到DataTable
Range excelRange = excelWorksheet.UsedRange;
int rowCount = excelRange.Rows.Count;
int colCount = excelRange.Columns.Count;

for (int i = 1; i <= rowCount; i++)
{
    DataRow row = dt.NewRow();
    for (int j = 1; j <= colCount; j++)
    {
        row[j - 1] = excelRange.Cells[i, j].Value2;
    }
    dt.Rows.Add(row);
}

// 绑定数据到Datagrid
datagrid.DataSource = dt;
datagrid.DataBind();