Hello,
I am using a client-side solution to export kendo grid data to Excel. I would like to be able to include line breaks within each cell. \r, \n, <br />, and don't work. Here's some sample code:
// ...
excelExport: function (e) {
var sheet = e.workbook.sheets[0];
var skillsIndex = 0;
// First row. Find the skills column, and set the index.
for (var i = 0; i < sheet.rows[0].cells.length; i++)
{
if (sheet.rows[0].cells[i].value == "Skills")
{
skillsIndex = i;
break;
}
}
for (var j = 1; j < sheet.rows.length; j++)
{
sheet.rows[j].cells[skillsIndex].value = "We got skills!";
// doesn't break the line between got and skills -- how to do so?
}
}
// ...
Thank you for any help you can provide!