jQuery Grid Plugin - jqGrid - Topic: Issue while exporting current jq grid data to excel. http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel Simple:Press Version 5.7.5.3 tony on Issue while exporting current jq grid data to excel. http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31316 Discussion http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31316 Hello,

 

In this case I recommend you to use server side export to excel string instead of client side.

 

Regards

]]> Thu, 30 Oct 2014 16:31:24 +0200 mcfarland on Issue while exporting current jq grid data to excel. http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31315 Discussion http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31315 Hi Tony,

          Thanks for responding.

One possible solution is to use getrowdata, but with number of records relative big by example 1000.

 

the problem is i canuse get row data for filtered records but when you want  to select all the records to export to excel only first page is capturing suppose if i have 670 pages in that only first page records is showing in the excel..

]]> Thu, 30 Oct 2014 16:12:44 +0200 tony on Issue while exporting current jq grid data to excel. http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31308 Discussion http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31308 Hello,

 

This request is discussed many times.

One possible solution is to use getrowdata, but with number of records relative big by example 1000.

 

Kind Regards

]]> Thu, 30 Oct 2014 13:46:58 +0200 mcfarland on Issue while exporting current jq grid data to excel. http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31301 Discussion http://www.trirand.com/blog/?page_id=393/discussion/issue-while-exporting-current-jq-grid-data-to-excel#p31301 hi,

 i am using filter tool bar on export to excel

$("#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");

}

 

This is my ExportJQGridDataToExcel function.

 

function

ExportJQGridDataToExcel(tableCtrl, excelFilename) {

var allJQGridData = $(tableCtrl).jqGrid('getRowData');

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

 

when i use this

var allJQGridData = $(tableCtrl).jqGrid('getGridParam', 'data');  it will give all the records in the grid

when i use this

var allJQGridData = $(tableCtrl).jqGrid('getRowData'); it will give the filtered records and only first page is capturing.

 

Can any one plz help me out how to solve this issue,How can i get all the records in the grid as well as when i filter i need to get selected records.

]]> Mon, 27 Oct 2014 21:35:12 +0200