Export to Excel with line breaks

[upstate18Participant]

In my grid I have a column which contains line breaks. I am able to display this fine within the grid with the following bit of code in the cellsRenderer property: return value.replace(/\n/g, '<br />'); however I am unable to maintain this formatting when I export to excel using the exportdata method. $("#jqxGrid").jqxGrid('exportdata', 'xls', 'jqxGrid'); Are their ways to format the text in a specific column during the export?

Thanks.

[TodorParticipant]

Hello upstate18,

The Grid exports the rows with their cell values. The exporter does not take into account the “cellsrenderer” callbacks because you can put any HTML in the cells which may not be exportable.

Let us know if you need further assistance.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[Author]

Posts