net导入excel到数据库

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

public void ReadExcel(string filePath)
{
    using (FileStream fileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read))
    {
        IWorkbook workbook = new HSSFWorkbook(fileStream);
        ISheet sheet = workbook.GetSheetAt(0);
        foreach (IRow row in sheet)
        {
            // 处理每一行数据
        }
    }
}

using System.Data.SqlClient;

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