c# 操作excel

来源：互联网发布：知乎童谣事件编辑：程序博客网时间：2024/06/05 23:31

OleDbConnection conn = null;
            try
            {
               `string strConn;
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source="+path+";"+
                "Extended Properties='Excel 8.0;'";

                conn = new OleDbConnection(strConn);
                conn.Open();
                string Sql = "select * from [list$]";
                System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                OleDbDataAdapter ddp = new OleDbDataAdapter(Sql, conn);
                DataSet ds = new DataSet();
                ddp.Fill(ds);
                //cmd.Connection = conn;
                 //在Excel的Sheet1的A3到H3处插入数据
                //cmd.CommandText = "insert into [Sheet1$A3:H3] (F1,F2,F3,F4,F5,F6,F7,F8) values('" + a200.Date + "','"
                //    + a200.PreviousClosePrice + "','" + a200.OpenPrice + "','" + a200.High + "','" + a200.Low + "','" + a200.Close + "','" +
                //    a200.Change + "','" + a200.ChangeRate + "')";

// update [list$] set b='s' where b=''

              //
                //cmd.ExecuteNonQuery();
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
                conn.Close();
            }
            catch (Exception ee)
            {
                if (conn != null)
                    conn.Close();
                //Console.WriteLine(e.ToString());
            }