Multi row in one td not show in excel report

engineer_yasin

Like the example below, I want Test 1 and Test 2 to be displayed in Excel output in two columns,
but in output in one column and one row.
Please advise

http://live.datatables.net/pucuqetu/3/

rf1234

https://datatables.net/reference/button/excelHtml5

... and this won't be easy unless you really love XML, jQuery manipulations of XML and are really skillful in it

Here are a couple of examples on what you can do with the Excel export.
https://datatables.net/forums/discussion/45846/datatable-excel-export-how-can-we-apply-multiple-styles-to-same-cell/p1

One is also on copying and pasting content from one cell to another.

You would probably need to insert an empty column and then copy and paste the second line of your cell (or a substring of the cell's content) to the newly created column.

Good luck!