Export particular columns in jqxGrid

[chengamkathiravanParticipant]

Hi,

We have 5 columns in jqxGrid. In these columns one of column is image column. While exporting we want to exclude(leave) this image column.

Please provide sample code to do it at earliest.

Best Regards
Bala.

[Peter StoevKeymaster]

Hi Bala,

Each column has “exportable” property which you can set to either true or false. Set it to false to disable the exporting.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[chengamkathiravanParticipant]

Hi Peter,

Thanks. Now we can exclude particular column while exporting after setting “exportable” property to false.

Meanwhile we are facing one more problem. We have one date column. It has swedish format date value as “2014-02-04”

grid has below declaration for that field.
{ text: ‘Delivered’, datafield: ‘Delivered’, width: 150, renderer: columnrenderer },

In columnrenderer event we are aligning header text only.

While exporting we are not able to see the the Delivered values. Only Header only coming in xls or pdf.

Please help in this regard

Best Regards
Bala.

[Peter StoevKeymaster]

Hi Bala,

That is because the Grid exports the “Text” not the custom HTML which you render within the columnrenderer. The same is valid if you implemented cellsrenderer. jqxGrid will always export only the Cell Values and the Column Header Text. It would not take into account custom HTML renderers.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts