hi tony,

             i didn’t understood your answer.

We are using filter tool bar on export to excel;the export to excel code was copied from code project (Mikes).The problem is that we are able to get all the records to excel from grid,when we filter with particular name we get some records like 10 records i need those 10 records to excel ,if we do filter also we are getting all the records to excel not filtered records.

$(“#list”).jqGrid(‘filterToolbar’, { stringResult: true, searchOnEnter: true, defaultSearch: “cn” }).navButtonAdd(

‘#pager’, {caption:”Export to Excel”,

buttonicon:”ui-icon-disk”,

onClickButton:function() {ExportDataToExcel(“#list”);

},

position:”last”

});

 

function ExportDataToExcel(tableCtrl) {

ExportJQGridDataToExcel(tableCtrl,”sample.xlsx”);

}

 

function ExportJQGridDataToExcel(tableCtrl, excelFilename) {  

var allJQGridData = $(tableCtrl).jqGrid(‘getGridParam’, ‘data’);

 // var allJQGridData = $(tableCtrl).jqGrid(‘getRowData’);

 var jqgridRowIDs = $(tableCtrl).getDataIDs(); // Fetch the RowIDs for this grid

 var headerData = $(tableCtrl).getRowData(jqgridRowIDs[0]);

If i comment getgrid param and if i use getrowdata i cna get filtered records but not all …

i want to satisy both the condiitons how can i acheive this..