.netexcel导入sql数据库

using System.IO;
using OfficeOpenXml;

public void ReadExcelFile(string filePath)
{
    if (!File.Exists(filePath))
    {
        throw new FileNotFoundException("Excel 文件不存在");
    }

    using (var package = new ExcelPackage(new FileInfo(filePath)))
    {
        var worksheet = package.Workbook.Worksheets[0];
        foreach (var row in worksheet.Rows)
        {
            // 处理每一行数据
        }
    }
}

using System.Data.SqlClient;

public void InsertDataToSql(string connectionString, DataTable dataTable)
{
    using (var connection = new SqlConnection(connectionString))
    {
        connection.Open();
        foreach (DataRow row in dataTable.Rows)
        {
            var sql = "INSERT INTO YourTable (Column1, Column2) VALUES (@Column1, @Column2)";
            using (var command = new SqlCommand(sql, connection))
            {
                command.Parameters.AddWithValue("@Column1", row["Column1"]);
                command.Parameters.AddWithValue("@Column2", row["Column2"]);
                command.ExecuteNonQuery();
            }
        }
    }
}

public bool ValidateData(DataRow row)
{
    if (row["Column1"] == DBNull.Value || string.IsNullOrEmpty(row["Column1"].ToString()))
    {
        return false;
    }

    // 其他验证逻辑

    return true;
}