操作excel

try
                    {
                        string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e://aa.xls;Extended Properties=Excel 8.0;";
                        OleDbConnection conn = new OleDbConnection(strConn);
         System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
                        conn.Open();                       
                        cmd.Connection = conn;
                      
                        for (int i = 0; i < dgv.Rows.Count; i++)
                        {
                            cmd.CommandText = "INSERT INTO [sheet1$] (aa,bb) VALUES('" + dgv.Rows[i].Cells[0].Value + "','"
 + dgv.Rows[i].Cells[1].Value + "')";

                            cmd.ExecuteNonQuery();                          
                        }
                        conn.Close();
                      
                    }
                    catch (System.Data.OleDb.OleDbException ex)
                    {
                        System.Diagnostics.Debug.WriteLine("写入Excel发生错误：" + ex.Message);
                    }