exporting grid in excel

[rajivMember]

Hi

when I try to export data in excel formate, it gives error for me- “Uncaught TypeError: Cannot call method ‘toString’ of null “. I am using this method – $(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xls’, ‘Name’).

When I trace this issue, I realize that it give error ,only if the grid having null value in there column.

Could you please tell me how to resolve this issue.

Regards
Rajiv Kumar

[Peter StoevKeymaster]

Hi Rajiv Kumar,

From your other post: http://www.jqwidgets.com/community/topic/export-grid-data/ I understand that you do not use the latest version. Please, report issues that are valid for the latest version. At present, we cannot reproduce such behavior.

Best Regards,
Peter Stoev

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

[rajivMember]

Hi Peter,

Thanks for you reply. You mean if I use latest version this issue will not occur. Am I right?

Also there is one more question, I am using image button in grid, currently this also an issue. Did you covered this issue as well in latest version?

Regards
Rajiv Kumar

[Peter StoevKeymaster]

Hi Rajiv Kumar,

We cannot export images to excel. No, that is not covered and it is not planned to be. I just meant that if you wish to report an issue, please test it first with the latest version and if you can reproduce it with it, then report it.

Best Regards,
Peter Stoev

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

[rajivMember]

Hi Peter,

I downloaded new version of jqwedgets (jQWidgets v3.0.2 (2013-August-26)), But still I am facing the same same issue, if the column having null value then it does not allow to export the that.

I just replace the new jquery file with older one, do I need to modify elsewhere in code?

Regards
Rajiv Kumar

[Peter StoevKeymaster]

Hi Rajiv Kumar,

We cannot reproduce such behavior. If you experience issues, please provide a sample which demonstrates it.

Best Regards,
Peter Stoev

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

[rajivMember]

Hi Peter

Please check the this link- http://jsfiddle.net/2SWUZ/ where you can see the error.

Here I have made first column (first Name )as null, If I try to export it in excel, It throw error as given above.

This throw error only for excel export, for other it works fine.

Please let me know how to overcome this.

Regards
Rajiv Kumar

[Peter StoevKeymaster]

Hi Rajiv Kumar,

Thank you for the provided sample. By testing with your sample, we confirm the reported behavior and we added a work item about it. The fix is scheduled for the next release.

Best Regards,
Peter Stoev

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

[Author]

Posts