excel sql语句修改

protected void Button1_Click(object sender, EventArgs e)
    {
        DoSql("update [139$] set A1='1'", "d://z1.xls");
      
    }
    /// <summary>
    /// 通过sql语句，修改并保存Excel
    /// </summary>
    /// <param name="strsql"></param>
    /// <param name="filepath"></param>
    private void DoSql(string strsql, string filepath)//这里的strsql指要执行的sql语句，filepath指Excel的路径，例如"E://1.xls"
    {
        
            string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=no;IMEX=0'";//连接Excel OLEDB协议
            OleDbConnection oledCon = new OleDbConnection(ConnectionString);//创建连接对象
            oledCon.Open();//开启连接
            OleDbCommand oledCom = new OleDbCommand(strsql, oledCon);//
            oledCom.ExecuteNonQuery();//执行sql语句
            oledCon.Close();//关闭连接
    }