在我的WPF应用程序中将Excel电子表格数据导入SQLiite数据库

using System.Data;
using System.Data.SQLite;
using Excel = Microsoft.Office.Interop.Excel;

// 打开Excel文件
Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open("YourExcelFile.xlsx");
Excel.Worksheet worksheet = workbook.Sheets[1];

// 读取Excel数据
int rowCount = worksheet.UsedRange.Rows.Count;
int colCount = worksheet.UsedRange.Columns.Count;

// 建立与SQLite数据库的连接
string connectionString = "Data Source=YourSQLiteDatabase.db";
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
    connection.Open();

    // 创建表格
    string createTableQuery = "CREATE TABLE IF NOT EXISTS TableName (Column1 TEXT, Column2 INTEGER)";
    using (SQLiteCommand createTableCommand = new SQLiteCommand(createTableQuery, connection))
    {
        createTableCommand.ExecuteNonQuery();
    }

    // 插入数据
    for (int row = 1; row <= rowCount; row++)
    {
        string column1Value = worksheet.Cells[row, 1].Value.ToString();
        int column2Value = Convert.ToInt32(worksheet.Cells[row, 2].Value);

        string insertDataQuery = "INSERT INTO TableName (Column1, Column2) VALUES (@Column1, @Column2)";
        using (SQLiteCommand insertDataCommand = new SQLiteCommand(insertDataQuery, connection))
        {
            insertDataCommand.Parameters.AddWithValue("@Column1", column1Value);
            insertDataCommand.Parameters.AddWithValue("@Column2", column2Value);
            insertDataCommand.ExecuteNonQuery();
        }
    }

    // 关闭连接
    connection.Close();
}

// 关闭Excel文件
workbook.Close();
excelApp.Quit();