使用c#将Excel文件导入到现有sqli文件中

using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.Office.Interop.Excel;

string connectionString = "Data Source=数据库服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码;";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

Application excel = new Application();
Workbook workbook = excel.Workbooks.Open("Excel文件路径");
Worksheet worksheet = workbook.Sheets[1]; // 假设要导入的数据在第一个工作表中
Range range = worksheet.UsedRange; // 获取使用的数据范围

for (int row = 2; row <= range.Rows.Count; row++) // 假设第一行是表头，从第二行开始遍历数据
{
    string column1Value = ((Range)range.Cells[row, 1]).Value2.ToString(); // 假设第一列是要插入的数据
    string column2Value = ((Range)range.Cells[row, 2]).Value2.ToString(); // 假设第二列是要插入的数据

    string insertQuery = "INSERT INTO 表名 (列1, 列2) VALUES (@Value1, @Value2)";
    SqlCommand command = new SqlCommand(insertQuery, connection);
    command.Parameters.AddWithValue("@Value1", column1Value);
    command.Parameters.AddWithValue("@Value2", column2Value);
    command.ExecuteNonQuery();
}

workbook.Close();
excel.Quit();
connection.Close();