jQuery Grid Plugin - jqGridForum

Topic RSS

Export jQGrid data to Excel - Solution that worked for me

04/02/2009
12:51

seetharaman

Member

Members

Forum Posts: 12

Member Since:
20/06/2008

Offline

I use the following javascript function from my code to export the jQGrid data. This works for me. I use a JSP to open the excel. Same code can be simulated in PHP also. Hope someone will benefit from this snippet

// This is the JSP code to output the file in excel
//<%
//

//response.setContentType("application/vnd.ms-excel");
//String buf=request.getParameter("csvBuffer");
//try{response.getWriter().println(buf);}catch(Exception e){}
//%>

}

05/02/2009
02:16

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Thank you for shering the code with the community.

Regards

Tony

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.

09/03/2009
13:03

Jim P

Member

Members

Forum Posts: 102

Member Since:
29/01/2009

Offline

When I try the code I get the following error:

document.formstyle is undefined

in Firebug.

on this line:

document.formstyle.csvBuffer.value=html;

which is the first one of that type. I'm not a php coder and just a beginner with js and jqgrid. Any help would be appreciated.

TIA

Jim

01/09/2009
16:29

betty

Member

Members

Forum Posts: 22

Member Since:
24/06/2009

Offline

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

"mya=jQuery(”#list2″).getDataIDs(); // Get All IDs"

If I like to export all data (e.g. totally 18 records, 10 displayed in current grid and 8 in second grid page), is there a way to capture all 18 records without invoking the backend?

Thanks.

Betty

10/10/2014
02:57

mcfarland

Member

Members

Forum Posts: 11

Member Since:
07/10/2014

Offline

Hi betty,

Â Â Â Â Â Â Â Â Â Â Â Â Â I am wondering like if you find the solution for (

If I like to export all data (e.g. totally 18 records, 10 displayed in current grid and 8 in second grid page), is there a way to capture all 18 records without invoking the backend?)

because mine also the same problem,i am not finding any solution only first page data is capturing in excel ...

I am using

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

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

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

Plz help me out.....

21/10/2014
15:56

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

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.

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

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.

21/10/2014
22:25

Jim P

Member

Members

Forum Posts: 102

Member Since:
29/01/2009

Offline

Hi Betty,

I created my grids a few years ago and there wasn't away to dump everything to excel.

All of my pages use a Cold Fusion cfc function on the server end.Â Before I return the data I set a session variable to the value of the query data.

here's and example: I have a function that returns different types of sales orders (phone orders, shipped, not shipped)

Â Â 
Â Â Â Â <cfswitch expression="#Arguments.OpenShpd#">
Â Â Â Â Â Â <cfcase value="O"><cfset session.DumpSO = get_so></cfcase>
Â Â Â Â Â Â <cfcase value="N"><cfset session.DumpSNS = get_so></cfcase>
Â Â Â Â Â Â <cfcase value="S"><cfset session.DumpSOS = get_so></cfcase>
Â Â Â Â </cfswitch>

Then on my gridpage above my grid I have linksÂ Â [To PDF]Â Â andÂ [To Excell] options (these icons and words)

When the user clicks one of these links it sends them to a page that recreates the data in the the chosen format.

Because these are links I can passÂ url parameters using jquery to gather filter data.

Jim

Â Â

29/10/2014
18:14

mcfarland

Member

Members

Forum Posts: 11

Member Since:
07/10/2014

Offline

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

30/10/2014
14:31

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

I have already answer of your question.

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.