public static String PathByConfig = Directory.GetCurrentDirectory();//获取运行目录的路径
public static String Path_Str = PathByConfig +"\\test.xls";
String connStr = @"Provider= Microsoft.ACE.OLEDB.12.0;Jet OLEDB:DataBase Password=;Data Source="+ Path_Str+";"+ "Extended Properties='Excel 8.0;HDR=YES;IMEX=0';";//(这里IMEX=0,才不会出现System.Data.OleDb.OleDbException:“操作必须使用一个可更新的查询。”的问题)
//声明
private OleDbConnection conn = null;
private void Form1_Load(object sender, EventArgs e)
{
conn = new OleDbConnection(connStr);
// 打开数据库连接
conn.Open();
String Sql = "INSERT INTO [Sheet1$] (NUM1,Stu) VALUES('2','刘六')";
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand(Sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}