asp.net xls导入数据库

using System.IO;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

public void ReadExcel(string filePath)
{
    try
    {
        using (FileStream fileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read))
        {
            IWorkbook workbook = new HSSFWorkbook(fileStream);
            // 读取工作表数据
        }
    }
    catch (Exception ex)
    {
        Console.WriteLine("读取Excel文件失败: " + ex.Message);
    }
}

// 假设数据库表中的列类型为 int
int value = int.Parse(cell.Value.ToString());
// 如果转换失败，可以捕获异常并处理
try
{
    value = int.Parse(cell.Value.ToString());
}
catch (FormatException)
{
    value = 0; // 或者其他默认值
}

using System.Data.SqlClient;

public void InsertDataToDatabase(string connectionString, string tableName, DataTable dataTable)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
        {
            bulkCopy.DestinationTableName = tableName;
            bulkCopy.WriteToServer(dataTable);
        }
    }
}