操作excel,进行新增,查询,修改

打开连接string str = System.IO.Path.GetFullPath("文件.xlsx");


string StrConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + str +
";Extended Properties='Excel 8.0;HDR=Yes'";


OleDbConnection MyConn = new OleDbConnection(StrConn);MyConn.Open();


查询赋值
string StrCmd = "select * from [sheet1$]"
OleDbDataAdapter MyCommand = new OleDbDataAdapter(StrCmd, MyConn);
DataSet Ds = new DataSet();
MyCommand.Fill(Ds, "MyTable");
DataTable dt = Ds.Tables["MyTable"];


释放资源
MyConn.Close();
MyConn.Dispose();

新增
string sql = @"insert into [Sheet1$] (字段1,字段2...) values(值1,值2...)
command = new OleDbCommand(sql, MyConn);
command.ExecuteNonQuery();

编辑
string sql = @"update [Sheet1$] set 字段1=字段2 .....
command = new OleDbCommand(sql, MyConn);
command.ExecuteNonQuery();

最近正好在弄excel所以分享下,有错误请大神指出