Excel Export in Jqgrid

[iamarshad]

I have a problem on exporting the Jdgrid table in a PHP Website. I used a button to call the Excel export function, but the function returns "Uncaught TypeError: Cannot read property 'indexOf' of null" and the error shows in this line if(o.url.indexOf("?") != -1) { url = o.url+"&"+params; }

of the excelexport function. The complete function in the Jqgrid.js is as follows

    excelExport : function(o) {
        o = $.extend({
            exptype : "remote",
            url : null,
            oper: "oper",
            tag: "excel",
            exportOptions : {}
        }, o || {});
        return this.each(function(){
            if(!this.grid) { return;}
            var url;
            if(o.exptype == "remote") {
                var pdata = $.extend({},this.p.postData);
                pdata[o.oper] = o.tag;
                var params = jQuery.param(pdata);
                if(o.url.indexOf("?") != -1) { url = o.url+"&"+params; }
                else { url = o.url+"?"+params; }
                window.location = url;
            }
        });

[tonytomov]

Hello,

We know this code very well, but we do not know your code, which causes this error.

Can you please post a demo which demonstrates the problem. Note we require tested and working demo which causes the problem.

Thank you

[iamarshad]

Hi, thanks in advance for helping..

Here's my code for the webpage, I have initiated a Jqgrid in this webpage to display a list of items from database. I want that data to be exported to excel format. That I could't able to do.

<?php $this->load->view('header') ?> <?php $this->load->view('navigation') ?>

session->userdata('msg')){ ?>

× session -> userdata('msg'); ?>

session->unset_userdata('msg'); ?>

Summary Report By Item.

x

Item Summary (Open Qty)

Print Close

x

Item Summary (Shipped to WF)

Print Close

x

New User Details

Team Number... 1 2

Is an admin?

Cancel Submit

<?php $this->load->view('footer') ?>

Kindly let me know if you have any questions on this code. I'll be online and clarify them. Thanks again