Issue When Exporting As CSV

[Sibeesh VenuParticipant]

HI,
I have populated the grid successfully , but now i am facing an issue while exporting as CSV. Please see the following image.

NB : observe the column name ‘Product margin-Excluding outliers’.
You can see additional characters there. Please help me resolve this issue.

Kindest Regards
Sibeesh

[DimitarParticipant]

Hello Sibeesh,

Please try the solution given here: http://www.jqwidgets.com/community/topic/excel-export-is-corrupted/#post-62561.

Best Regards,
Dimitar

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

[Sibeesh VenuParticipant]

Hi Dimitar,
I have found out what is the problem, in the image you can see a column called “Product Margin – Excluding Outliers (%) “ , actually my data set has it like Product Margin – Excluding Outliers (%).So (–) is being converted to the – while exporting.

Kindest Regrads
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
When I try export as Excel , I am getting this error “The server closed the connection without sending any data.” .Is there any limitation of data that we can export as excel in JQX Grid? I am having around 8k records in that particular grid. Can you please help me with this? Thanks in advance .

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
can’t we call export like this?
`$(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xls’, title, true, null, true, ‘http://localhost:58020/save-file.php’);
I have already got the licensed version , and placed in the root directory.

Kindest Regards
Sibeesh

[DimitarParticipant]

Hi Sibeesh,

Yes, this code should work fine to export the grid through your local server.

Best Regards,
Dimitar

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

[Sibeesh VenuParticipant]

Hi Dimitar,
I have got the license for JQWidgets under the mail id rajesh@customeranalytics.com. And we are developing this product for a client, I have talked with them regarding to host those export files in their server. They said they don’t have any server which supports PHP, we are using dot net as our platform, it supports dot net pages alone. My client is not ready to install PHP as well. Is there any fix you can provide me for this problem? I have already contacted Mr.Peter from your team,I am waiting for the reply for the past 3 days.Please reply me asap. Thank you.

Kindest Regards
Sibeesh

[Peter StoevKeymaster]

Hi Sibeesh,

The support is from Mon-Fri according to the Support Subscription and License Agreement. If you asked email on Friday afternoon, you will get response most probably on Monday. Today is Monday and we’ll reply you. The .NET exporting is included in the source code download package, too. In additon, don’t share information who your license owner is and don’t share your license key anywhere.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Sibeesh VenuParticipant]

Hi Peter,
Sorry for the mistake. And thanks a lot for the info 🙂 Do you have any demo for the same in Dot Net? Can you please say me the steps to do the same and which are all the files I may need to add? Waiting for the reply. Thanks in advance 🙂
Kindest Regards
Sibeesh

[Peter StoevKeymaster]

Hi Sibeesh,

The information you’re looking for is available in the source code download package. Download it and find the tutorial there.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Sibeesh VenuParticipant]

Hi Peter,
Thanks a lot for the info 🙂 You have given me a light 🙂 . Thank you. I will find it and work on it.
Kindest Regards
Sibeesh

[Author]

Posts