jqgrid how to export to excel

jimi boy

4y2.4kLearn iOS Programming

i am using on mvc project a jqgrid, i want to export the grid to excel.

my actual code:

@section scripts{

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

jimi boy4y ago
Sorry for the wrong title, i am using jqxGrid
Rijwan Ansari4y ago
You can check this article with example.
https://jeesite.gitee.io/front/jqGrid/5.4/jqgridjs/export/exporttoexcel/index.html

Sample:
"jqGrid">
    "export">Export to Excel


    "text/javascript">

        $(document).ready(function () {
            $("#jqGrid").jqGrid({
                url: 'data.json',
                datatype: "json",
                colModel: [
                    { label: 'Category Name', name: 'CategoryName', width: 75 },
                    { label: 'Product Name', name: 'ProductName', width: 90 },
                    { label: 'Country', name: 'Country', width: 100 },
                    { label: 'Price',
                        name: 'Price',
                        width: 80,
                        sorttype: 'number',
                        formatter: 'number',
                        align: 'right'
                    },
                    { label: 'Quantity', name: 'Quantity', width: 80, sorttype: 'integer' }
                ],
                loadonce: true,
                viewrecords: true,
                footerrow: true,
                userDataOnFooter: true, // use the userData parameter of the JSON response to display data on footer
                width: 780,
                height: 200,
                rowNum: 150
            });

            $("#export").on("click", function(){
                $("#jqGrid").jqGrid("exportToExcel",{
                    includeLabels : true,
                    includeGroupHeader : true,
                    includeFooter: true,
                    fileName : "jqGridExport.xlsx",
                    maxlength : 40 // maxlength for visible string data
                })
            })
        });
Muhammad Imran Ansari4y ago
Check, here's a nice article, showing you how to export from jqGrid to Excel:
https://www.codeproject.com/Tips/784342/Export-Data-from-jqGrid-into-a-real-Excel-File
Sachin Singh4y ago
include jszip cdn in your view page
"text/javascript" language="javascript" src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js">
create a button
"export">Export to Excel
download to excel
$("#export").on("click", function(){
                $("#jqGrid").jqGrid("exportToExcel",{
                    includeLabels : true,
                    includeGroupHeader : true,
                    includeFooter: true,
                    fileName : "jqGridExport.xlsx",
                    maxlength : 40 // maxlength for visible string data
                })
            })
        });