Forum
21:35
07/10/2014
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.
13:46
Moderators
30/10/2007
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
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
16:12
07/10/2014
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..
16:31
Moderators
30/10/2007
Hello,
Â
In this case I recommend you to use server side export to excel string instead of client side.
Â
Regards
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
72 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66