jqxGrid Export

[chethansParticipant]

Hi,

When I try to export jqxGrid data with multiple columns, only columns that are in visible on the screen will be exported. remaining columns that are seen moving horizontal columns around will be empty.

Kindly help me to resolve this.

Thanks in advance

[MariyaParticipant]

Hi chethans,

Please take a look at the provided example in which all of the columns are exported at: http://jsfiddle.net/jqwidgets/qs5mr/.
If you have more questions do not hesitate to contact us.

Best Wishes,
Mariya

jQWidgets Team
http://www.jqwidgets.com

[chethansParticipant]

Hi Mariya,

After long debugging, here is what i found out.

Here is my problem statement
1. add more then 10 column to grid.
2. Make sure width of the column will be such that horizontal scroll bar appears on the grid.
3. export data from the grid.
4. columns that are visible after scrolling will not exported to excel.
5. Please find below js fiddle link

http://jsfiddle.net/4zAHJ/216/

Note : Please check this in chrome browser

[Peter StoevKeymaster]

Solution: enablecolumnsvirtualization: false

Regards,
Peter

[chethansParticipant]

Thanks Peter. Great its working.

I have one more problem. I have SlNo column in the jqxGrid. How to exclude SlNo column while exporting?

Js fiddle for reference http://jsfiddle.net/4zAHJ/218/

[Peter StoevKeymaster]

Solution: exportable: false in the column’s settings.

Regards,
Peter

[chethansParticipant]

Thanks Peter. Great its working.

[Author]

Posts