在Excel中使用换行符将值导出为单个单元格。jQuery的datatable

I am successfully exporting HTML tables from a web application to excel using jQuery DataTables. However one particular column has values containg line breaks and tabs. I have managed to display the data correctly on the HTML table by replacing new lines (\n) and tabs (\t) with I am successfully exporting HTML tables from a