Retain linebreaks into one cell when exporting to excel.

mesqueeb

Dear community,
I'm stuck on this problem. And I've asked it on stackoverflow as well:

http://stackoverflow.com/questions/35761577/export-value-with-linebreaks-into-single-cell-in-excel-with-jquery-datatables-20

It would be great if anyone could help me out!
Best regards!

mesqueeb

The correct answer is:

data.replace( /<br\s*\/?>/ig, "\n" ) :

However, you need to press the "wrap text" button when opening the excel.
If someone knows a way to have it wrapped automatically, please let me know.

tombosch

This solution create a <br> instead of an line break. Any idea how to fix this?

Thanks!