jQWidgets Forums

Tagged: angular grid, excel, export, Exportdata, grid, jquery grid, jqxgrid, save-file.php, variable

This topic contains 21 replies, has 8 voices, and was last updated by Dimitar 8 years, 9 months ago.

Viewing 7 posts - 16 through 22 (of 22 total)

← 1 2

Author

Export jqxgrid to excel Posts

June 5, 2015 at 10:12 am Export jqxgrid to excel #72076

manojjoon

Participant

hii Dimitar,

i tried to generate export to excel but shows error on click as save-file.php
if i will took as local variable it will return data in xml format and could not able to save it also.

Please help my code is below

@{
    ViewBag.Title = "Export";
}

<html lang="en">
<head>
    <title id='Description'>With jqxGrid, you can export your data to Excel, XML, CSV, TSV, JSON, PDF and HTML.</title>
    <link href="../../Content/jqwidgets/styles/jqx.base.css" rel="stylesheet" type="text/css" />
    <script src="../../Content/js/jquery-1.11.3.min.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxcore.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxbuttons.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxscrollbar.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxmenu.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxcheckbox.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxgrid.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxgrid.selection.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxgrid.columnsresize.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxdata.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxdata.export.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxgrid.export.js" type="text/javascript"></script>
    <script src="../../Content/jqwidgets/jqxgrid.sort.js" type="text/javascript"></script>
    <script src="../../Scripts/tableExport.js" type="text/javascript"></script>
    <script src="../../Scripts/jquery.base64.js" type="text/javascript"></script>
    <script src="../../Scripts/html2canvas.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            // prepare the data
            var source =
            {
                datatype: "json",
                datafields: [
					 { name: 'regid', type: 'int' },
					 { name: 'fname', type: 'string' },
					 { name: 'lname', type: 'string' },
					 { name: 'sex', type: 'string' },
					 { name: 'profession', type: 'string' },
                     { name: 'dob', type: 'date' },
                     { name: 'emailid', type: 'string' },
                     { name: 'contactno', type: 'string' },
                     { name: 'username', type: 'string' },
                     { name: 'address', type: 'string' },
                     { name: 'state', type: 'string' },
                     { name: 'city', type: 'string' },
                     { name: 'pincode', type: 'string' },
                ],
                url: 'Employee/GetEmployees'
            };
            var dataAdapter = new $.jqx.dataAdapter(source);
            // initialize jqxGrid
            $("#grid").jqxGrid(
            {
                width: 850,
                source: dataAdapter,
                columns: [
                    { text: "regid", datafield: "regid" },
                    { text: "fname", datafield: "fname" },
                    { text: "lname", datafield: "lname" },
                    { text: "sex", datafield: "sex" },
                    { text: "profession", datafield: "profession" },
                    { text: "dob", datafield: "dob" },
                    { text: "emailid", datafield: "emailid" },
                    { text: "contactno", datafield: "contactno" },
                    { text: "username", datafield: "username" },
                    { text: "address", datafield: "address" },
                    { text: "state", datafield: "state" },
                    { text: "city", datafield: "city" },
                    { text: "pincode", datafield: "pincode" }
                ]
            });
            $("#excelExport").jqxButton({ theme: 'energyblue' });
            $("#xmlExport").jqxButton();
            $("#csvExport").jqxButton();
            $("#tsvExport").jqxButton();
            $("#htmlExport").jqxButton();
            $("#jsonExport").jqxButton();
            $("#pdfExport").jqxButton();

           
            var exportInfo;
            $("#excelExport").click(function () {
                exportInfo = $("#grid").jqxGrid('exportdata', 'xls');
            });

            $("#xmlExport").click(function () {
                $("#grid").jqxGrid('exportdata', 'xml', 'grid');
            });
            $("#csvExport").click(function () {
                $("#grid").jqxGrid('exportdata', 'csv', 'grid');
            });
            $("#tsvExport").click(function () {
                $("#grid").jqxGrid('exportdata', 'tsv', 'grid');
            });
            $("#htmlExport").click(function () {
                $("#grid").jqxGrid('exportdata', 'html', 'grid');
            });
            $("#jsonExport").click(function () {
                $("#grid").jqxGrid('exportdata', 'json', 'grid');
            });
            $("#pdfExport").click(function () {
                $("#grid").jqxGrid('exportdata', 'pdf', 'grid');
            });
        });
    </script>
</head>
<body class='default'>
    <div id='jqxWidget' style="font-size: 13px; font-family: Verdana; float: left;">
        <div id="grid"></div>
       <div style='margin-top: 20px;'>
            <div style='float: left;'>
                <input type="button" value="Export to Excel" id='excelExport' />
                <br /><br />
                <input type="button" value="Export to XML" id='xmlExport' />
            </div>
            <div style='margin-left: 10px; float: left;'>
                <input type="button" value="Export to CSV" id='csvExport' />
                <br /><br />
                <input type="button" value="Export to TSV" id='tsvExport' />
            </div>
            <div style='margin-left: 10px; float: left;'>
                <input type="button" value="Export to HTML" id='htmlExport' />
                <br /><br />
                <input type="button" value="Export to JSON" id='jsonExport' />
            </div>
            <div style='margin-left: 10px; float: left;'>
                <input type="button" value="Export to PDF" id='pdfExport' />
            </div>
        </div>
    </div>
</body>
</html>

June 5, 2015 at 10:33 am Export jqxgrid to excel #72077

Dimitar

Participant

Hi manojjoon,

What is the error you receive regarding save-file.php?

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

July 9, 2015 at 1:10 pm Export jqxgrid to excel #73577

fdski

Participant

Hi Dimitar,

We have licence purchased – how do we go about getting save-file.php ? Is there a separate download ?

July 9, 2015 at 1:16 pm Export jqxgrid to excel #73578

Dimitar

Participant

Hi B,

It is available along with the jQWidgets source code from the Client Services Portal. For more information, please check the email you have received after purchasing the license.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

July 9, 2015 at 1:20 pm Export jqxgrid to excel #73579

fdski

Participant

nevermind, we got it 🙂

July 18, 2016 at 3:23 pm Export jqxgrid to excel #85833

WeitzLux

Participant

Hi,
I am not able to see the ‘save-file.php’ in source code. We have a enterprise license. Please let me know the I want to host this file on our server.

July 19, 2016 at 5:07 am Export jqxgrid to excel #85843

Dimitar

Participant

Hi WeitzLux,

You can find the export PHP file in the jQWidgets Source code package (accessible from the jQWidgets Client Portal) in the folder PHPExport.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

Author

Posts

Viewing 7 posts - 16 through 22 (of 22 total)

← 1 2

You must be logged in to reply to this topic.