Export data in jQgrid to pdf from jquery code

Question

I am using a jQgrid in my page. I need to export the data shown in the grid to pdf and excel. I have created a button and added a code like

 jQuery("#btnExportPdf").on("click", function(){
                jQuery("#jqGrid").jqGrid("exportToPdf",{
                    title: 'Export to PDF',
                    orientation: 'portrait',
                    pageSize: 'A4',
                    description: 'Meeting Details',
                    customSettings: null,
                    download: 'download',
                    includeLabels : true,
                    includeGroupHeader : true,
                    includeFooter: true,
                    fileName : "Meetings.pdf"
                })
            })

What else I need to do?

score 1 · Accepted Answer · answered Jun 01 '17 at 06:33

Try using this function

    function exportGrid() {
        mya = $("#" + table).getDataIDs(); // Get All IDs
        var data = $("#" + table).getRowData(mya[0]); // Get First row to get the
        // labels
        var colNames = new Array();
        var ii = 0;
        for (var i in data) {
            colNames[ii++] = i;
        } // capture col names

        var html = "<html><head>"
        + "<style script=&quot;css/text&quot;>"
        + "table.tableList_1 th {border:1px solid black; text-align:center; "
        + "vertical-align: middle; padding:5px;}"
        + "table.tableList_1 td {border:1px solid black; text-align: left; vertical-align: top; padding:5px;}"
        + "</style>"
        + "</head>"
        + "<body style=&quot;page:land;&quot;>";


        for (var k = 0; k < colNames.length; k++) {
            html = html + "<th>" + colNames[k] + "</th>";
        }
        html = html + "</tr>"; // Output header with end of line
        for (i = 0; i < mya.length; i++) {
            html = html + "<tr>";
            data = $("#" + table).getRowData(mya[i]); // get each row
            for (var j = 0; j < colNames.length; j++) {
                html = html + "<td>" + data[colNames[j]] + "</td>"; // output each Row as
                // tab delimited
            }
            html = html + "</tr>"; // output each row with end of line
        }
        html = html + "</table></body></html>"; // end of line at the end
        alert(html);
        html = html.replace(/'/g, '&apos;');
    }

Reference

There is not showing any link for marking as duplicate at my end that's why I do this @DipenShah — Manoj, Jun 02 '17 at 04:18

Export data in jQgrid to pdf from jquery code

1 Answers1