Forum

July 12th, 2025
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
ExcelExport
19/11/2010
23:25
Avatar
LottaSmiles
Member
Members
Forum Posts: 3
Member Since:
20/11/2010
sp_UserOfflineSmall Offline

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();
       }

});    

03/12/2010
17:10
Avatar
johan
USA
Member
Members
Forum Posts: 13
Member Since:
02/12/2010
sp_UserOfflineSmall Offline

I am actually having the exact same issue.

03/12/2010
17:31
Avatar
rmvenancio
Portugal
Member
Members
Forum Posts: 12
Member Since:
09/11/2010
sp_UserOfflineSmall Offline

Mine is working with this line of code :

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

05/12/2010
05:36
Avatar
johan
USA
Member
Members
Forum Posts: 13
Member Since:
02/12/2010
sp_UserOfflineSmall Offline

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. 

06/12/2010
20:37
Avatar
LottaSmiles
Member
Members
Forum Posts: 3
Member Since:
20/11/2010
sp_UserOfflineSmall Offline

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

10/12/2010
15:36
Avatar
rmvenancio
Portugal
Member
Members
Forum Posts: 12
Member Since:
09/11/2010
sp_UserOfflineSmall Offline

LottaSmiles,

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

Good luck,

15/12/2010
21:34
Avatar
davgino
Member
Members
Forum Posts: 31
Member Since:
20/03/2010
sp_UserOfflineSmall Offline

but for PDF ?

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

not working??

17/12/2010
15:43
Avatar
davgino
Member
Members
Forum Posts: 31
Member Since:
20/03/2010
sp_UserOfflineSmall Offline

i found.

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

07/07/2011
06:32
Avatar
deived
New Member
Members
Forum Posts: 1
Member Since:
07/07/2011
sp_UserOfflineSmall Offline

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

Thank you

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

Currently Online:
19 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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information