.netexcel导入数据库

using OfficeOpenXml;

public void ReadExcelFile(string filePath)
{
    try
    {
        var fileInfo = new FileInfo(filePath);
        using (var package = new ExcelPackage(fileInfo))
        {
            var worksheet = package.Workbook.Worksheets[0];
            foreach (var row in worksheet.Rows)
            {
                // 处理每一行的数据
            }
        }
    }
    catch (Exception ex)
    {
        Console.WriteLine("读取 Excel 文件时出错: " + ex.Message);
    }
}

using System.Data.SqlClient;

public void InsertDataToDatabase(string connectionString, DataTable dataTable)
{
    try
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            foreach (DataRow row in dataTable.Rows)
            {
                string sql = "INSERT INTO YourTable (Column1, Column2) VALUES (@Column1, @Column2)";
                using (SqlCommand command = new SqlCommand(sql, connection))
                {
                    command.Parameters.AddWithValue("@Column1", row["Column1"]);
                    command.Parameters.AddWithValue("@Column2", row["Column2"]);
                    command.ExecuteNonQuery();
                }
            }
        }
    }
    catch (Exception ex)
    {
        Console.WriteLine("插入数据到数据库时出错: " + ex.Message);
    }
}