更新Excel数据库记录

VB C#

using IronXL;
using System.Data;
using System.Data.SqlClient;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Convert the workbook to ToDataSet
DataSet dataSet = workBook.ToDataSet();

// Your sql query
string sql = "SELECT * FROM Users";

// Your connection string
string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    // Open connections to the database
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);

    // Update the values in database using the values in Excel
    adapter.Update(dataSet);
}

Imports IronXL
Imports System.Data
Imports System.Data.SqlClient

' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")

' Convert the workbook to ToDataSet
Private dataSet As DataSet = workBook.ToDataSet()

' Your sql query
Private sql As String = "SELECT * FROM Users"

' Your connection string
Private connectionString As String = "Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True"
Using connection As New SqlConnection(connectionString)
	' Open connections to the database
	connection.Open()
	Dim adapter As New SqlDataAdapter(sql, connection)

	' Update the values in database using the values in Excel
	adapter.Update(dataSet)
End Using

Install-Package IronXL.Excel

更新Excel数据库记录

IronXL 的ToDataSet方法允许开发人员以最小的努力直接从 Excel 数据同步和更新 SQL 数据库记录。此功能通过将 Excel 工作簿转换为DataSet ，实现了表格 Excel 数据与关系数据库之间的无缝集成。它无需手动输入数据或进行复杂的转换，从而大大简化了数据管理工作流程。

此功能对于需要定期从外部 Excel 文件更新数据库记录的应用程序（例如客户数据、财务记录或库存管理系统）尤其有用。与 SQL 查询和适配器的兼容性使开发人员能够将 Excel 数据映射到现有的数据库架构。 IronXL 支持多种 Excel 格式（XLSX、CSV 等），确保在各种使用场景中的通用性。此功能利用SqlDataAdapter进行批量更新，从而减少数据处理时间，最大限度地减少错误，并确保 Excel 和数据库记录之间的一致性，使其成为企业级应用程序的理想解决方案。

五个步骤教你如何将 Excel 数据更新到 SQL 数据库

var workBook = WorkBook.Load("产品.xlsx");
<代码>DataSet dataSet = workBook.ToDataSet();
string sql = "SELECT * FROM products";字符串


        using var adapter = new SqlDataAdapter(sql, new SqlConnection("Your Connection String"));
        new SqlCommandBuilder(adapter).DataAdapter.Update(dataSet);


这段代码演示了使用 IronXL 和 ADO.NET 用 Excel 文件中的数据更新 SQL 数据库的过程。 The WorkBook.Load method loads the Excel file named Products.xlsx into memory, and the ToDataSet method converts the workbook into a DataSet, which organizes the data into a tabular structure compatible with ADO.NET.
A SQL query is defined to interact with a specific table in the database (products). The SqlDataAdapter is initialized with the query and a connection string, enabling it to act as a bridge between the DataSet and the database. The SqlCommandBuilder is used to automatically generate the necessary SQL commands for inserting, updating, or deleting data in the database. Finally, the adapter.Update(dataSet) method synchronizes the changes in the DataSet (populated from the Excel file) with the corresponding database table. 这样可以简化数据传输过程，并确保数据库反映 Excel 文件中的最新更改。
了解如何使用 IronXL 将数据集导出到 Excel


					
    
        
            
                准备开始了吗？
                
                     Nuget 下载 1,765,830 | 版本: 2025.12 刚刚发布
            

            
            
                
                    
                        
                            
                            免费 NuGet 下载
                        
                        总下载量：1,765,830
                    
                
                

                
                    
                        查看许可证