export jqxgrid data to excel sheet locally

[Venu GopalParticipant]

when i try to export jqxgrid data to excel format it is connecting to some remote webservice which returns excel sheet. what i have to do if i want it to be done locally…

[DimitarParticipant]

Hello Venu Gopal,

Please check out the forum topic Export jqxgrid to excel. It has the answer to your question.

Best Regards,
Dimitar

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

[Venu GopalParticipant]

so i need to have developer or enterprise license for it to work without internet.
thank you.

[DimitarParticipant]

Hi Venu Gopal,

If you wish to export your grid to a variable, you are free to do so even without Developer or Enterprise license. Here is a code snippet, showing how to export a grid to a variable:

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

Best Regards,
Dimitar

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

[Venu GopalParticipant]

Thanks for your quick response.. able to download it locally.

[VivekParticipant]

Hey Dimitar,

I used the code snippet that u have given to fetch the data into a variable in jsp locally but I’m not able to see the data format. I tried alert in jsp it says ‘undefined’. Can you help me out here please.

[DimitarParticipant]

Hello Vivek,

What variable did you try to alert? Please share your code so that we may be able to help you.

Best Regards,
Dimitar

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

[snehaljadhavParticipant]

I have enterprise license, howeever export to excel is failing with below error. Not sure what to do.

Request Entity Too Large

The requested resource
/subfolder1/export_server/dataexport.php
does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.

[snehaljadhavParticipant]

Also i am using SharePoint and my user interface is plain html with backend SharePoint List and html pages are stored in SharePoint document library

[DimitarParticipant]

Hello snehaljadhav,

This is not actually related to jQWidgets but to a server-side setting that limits the upload/post size. Perhaps the following page will provide solution for you: https://social.msdn.microsoft.com/Forums/windowsapps/en-US/82556357-f004-4047-94d8-fdd231d14cfe/custom-sharepoint-wcf-rest-service-error-413-request-entity-too-large?forum=sharepointdevelopment.

Best Regards,
Dimitar

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

[Author]

Posts