jQuery Grid Plugin - jqGrid - Topic: ExcelExport

deived on ExcelExport

Thu, 07 Jul 2011 06:32:25 +0300

So whats inside the ExportExcel.php? or grid.php?

Thank you

davgino on ExcelExport

Fri, 17 Dec 2010 15:43:54 +0200

i found.

jQuery("#grid").jqGrid('excelExport',{tag:'pdf', url:'grid.php'})

davgino on ExcelExport

Wed, 15 Dec 2010 21:34:41 +0200

but for PDF ?

jQuery("#bigset").jqGrid('pdfExport', { url: 'ExportExcel.php' });

not working??

rmvenancio on ExcelExport

Fri, 10 Dec 2010 15:36:35 +0200

LottaSmiles,

About the data do be passed to the spreadsheet is a php problem. My knowlegde with php are basic.

Good luck,

LottaSmiles on ExcelExport

Mon, 06 Dec 2010 20:37:05 +0200

Thanks rmvenancio ! Mine works as well. The only problem now is how do I pass along the specific data to the spreadsheet?

johan on ExcelExport

Sun, 05 Dec 2010 05:36:24 +0200

rmvenancio said:

Mine is working with this line of code :

onClickButton: function () {
jQuery("#bigset").jqGrid('excelExport', { url: 'ExportExcel.php' });
}

Hey thanks for the reply, rmvenancio! I will try this first thing Monday morning... maybe sooner if I get a chance.

rmvenancio on ExcelExport

Fri, 03 Dec 2010 17:31:35 +0200

Mine is working with this line of code :

onClickButton: function () {
jQuery("#bigset").jqGrid('excelExport', { url: 'ExportExcel.php' });
}

johan on ExcelExport

Fri, 03 Dec 2010 17:10:02 +0200

I am actually having the exact same issue.

LottaSmiles on ExcelExport

Fri, 19 Nov 2010 23:25:47 +0200

This is my first time using jqueryGrid and I am not sure how to export my grid to excel. CAN SOMEONE PLEASE HELP ME OUT! This is what I have so far.

Once I click the Export to Excel button I get a error "a.url is null"

jQuery("#bigset").jqGrid({
   url:'bigset.php',
   datatype: "json",
   height: 255,
   colNames:['Serial','Name', 'Company'],
   colModel:[
       {name:'serial',index:'serial', width:200},
       {name:'name',index:'name', width:350},
       {name:'company',index:'company', width:200}
   ],
   rowNum:12,
   rowList:[10,20,30],
   mtype: "POST",
   pager: jQuery('#pagerb'),
   pgbuttons: true,
   pgtext: false,
   pginput:false,
   sortname: 'serial',
   viewrecords: true,
   sortorder: "asc"
   });

   var timeoutHnd;
   var flAuto = false;

   function doSearch(ev){
       if(!flAuto)
           return; //
       var elem = ev.target||ev.srcElement;
       if(timeoutHnd)
           clearTimeout(timeoutHnd)
           timeoutHnd = setTimeout(gridReload,500)
   }

       function gridReload(){
           var nm_mask = jQuery("#name").val();
           var cd_mask = jQuery("#company").val();
           jQuery("#bigset").jqGrid('setGridParam',{url:"bigset.php?nm_mask="+nm_mask+"&cd_mask="+cd_mask,page:1}).trigger("reloadGrid");
       }

       function enableAutosubmit(state){
           flAuto = state;
           jQuery("#submitButton").attr("disabled",state);
       }
   // Set navigator with search enabled.
       jQuery("#bigset").jqGrid('navGrid','#pagerb',{
                       add:false,
                       edit:false,
                       del:false});

   // add custom button to export the data to excel
   jQuery("#bigset").jqGrid('navButtonAdd','#pagerb',{
       caption:"Export to Excel",
       onClickButton : function () {
           jQuery("#bigset").excelExport();
       }

});