Hello,

Thank you for shering the code with the community.

Regards

Tony

Thanks for sharing the code. It works. But only the data in current grid was captured using the following method

Hello,

 

It is difficult.

If you use server side sorting and data, this should happen, sincxe the grid has only the needed portion.

If you use local data you can use the grid data parameter to get all the data.

 

Regards

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..