ADO.NET C# 填充 Excel 表格

发布于 2024-10-30 09:29:28 字数 570 浏览 0 评论 0原文

我想使用 ADO.NET 任务来实现此目的

：填充 Excel 文件中“RowNum”列的行，从 0 开始。每行将获得从 0 开始的递增值，直到存在的行数。

我想为第一行插入 1，为第二行插入 2，依此类推。请帮助我更新命令和要插入的值。非常感谢。

using (OleDbConnection conn = new OleDbConnection(getExcelConnectionString(new FileInfo(fName))))
            {
                conn.Open();
                OleDbCommand cmd = new OleDbCommand("Update [ExcelFile$] SET RowNum = ? WHERE ............ ", conn);

                    cmd.Parameters.Add("@rowNumber", OleDbType.Integer).Value = 
                    cmd.ExecuteNonQuery();
            }

原文

I want to achieve this using ADO.NET

Task: Populate the rows of the column "RowNum" in the excel file staring from 0. each row will get an incremented value starting from 0 until the number of rows present.

I want to insert 1 for the first row, 2 for the second row, and so on. please help me with the update command and the value to be inserted. Thank you very much.

using (OleDbConnection conn = new OleDbConnection(getExcelConnectionString(new FileInfo(fName))))
            {
                conn.Open();
                OleDbCommand cmd = new OleDbCommand("Update [ExcelFile$] SET RowNum = ? WHERE ............ ", conn);

                    cmd.Parameters.Add("@rowNumber", OleDbType.Integer).Value = 
                    cmd.ExecuteNonQuery();
            }

分享到QQ

分享到微博