I think am confusing it a bit. I am working on 2 things at once with no luck. I thought that the arrays were in order so that    closeAfterEdit: true, editCaption:”Update Row”, bSubmit:”Update” were all being done then the  add options, then the edit options, then the delete option arrays all kicked in??  the page reloads on the delete but not after the edit. and the excel part never shows on the screen at all.

jQuery(“#acct_list”).jqGrid(‘navGrid’,’#pager’,
{
add:false, edit:true, del:true, excel:true, edittext: ‘Edit’
},
{
closeAfterEdit: true, editCaption:”Update Row”, bSubmit:”Update”
},
//{}, // add options
{closeOnEscape:true,jqModal:true,bottominfo:”Fields marked with (*) are required”,
reloadAfterSubmit:false,
closeAfterEdit:true,
//afterSubmit:actionAfterSubmit
},// edit options
{reloadAfterSubmit:false} // del options

);

so i looked at the example and i figured out why mine was failing. i had an empty array for the add function that was false, that was making the attributes point to the wrong pieces of code.. so i resolved that now.

My issue is still that i want to delete the row after the edit. how do i call a something to remove the row from the grid  without reloading from the server? or for example after the edit is done i wanted an alert message to tell them the record was updated?  where would that code go?

also in this example i see excel:true but it is not showing the icon for the excel download?  i have that same issue.  does the icon not show up when the data is local?

I guess this explains my confusion.. I dont know what you mean when you say post it in the JS vs PHP forum?  my page is all php? I will rephrase the issue

1. the page loads using a json datatype with loadonce true
2. so now the data on the page is local when the data is returned.
3. the user has 10 records to choose to edit have excel:true set but the export icon does not show.
4. i created my own excel nav button and its clickable and the json url gets executed.  what i dont understand is how to send the data from the ajax call back to the page so that it can be downloaded.
5. i have an export file defined and i have the setexceloptions set
6. setExcelOptions:{“file_type”:”Excel2007″, //Excel2007,Excel5,xml
   “file”:”report.xlsx”,”start_cell”:”A1″,”creator”:”jqGrid”,”author”:”jqGrid”,
   path_to_phpexcel_class:”/global/libraries/guriddo/js/External/phpexcel/PHPExcel.php”},

but nothing happens when the data is returned. I dont see a demo of using these options only the excel:true option and when that is used nothing happens at all that i can see.

I dont see any examples that i can get to work.  if i use excel:true no export icon shows up. Many others have reported the same issue and I dont see what the answer is to that  problem.So i have no way to export the data. I have all the excel options set to what you have.

I tried using something like this with my own customer button

jQuery(“#acct_list”).jqGrid(‘navButtonAdd’,’#pager’,{
caption:”Export To Excel”,
onClickButton : function () {
var e = document.getElementById(“load_template”);
var the_template = e.options[e.selectedIndex].value;

jQuery(“#acct_list”).jqGrid(‘excelExport’,{“url”:”getEBKFSdata.php?&the_template=”+the_template});
});
}
});

this shows up and i can click it and call the php but nothing comes back the download and i am not clear how to format it in the php page that gets the data.  i dont see any examples of something like this.