I have the following code that inserts a value into an excel cell for export
context.Response.Write("aa\r\nbb\r\nccc");
o / r / n breaks the line but writes in the cell below, I would like to break the line but continue with the text in the same cell. How should I do it?
Here is the complete code
HttpContext context = HttpContext.Current;
context.Response.ContentEncoding = Encoding.GetEncoding("ISO-8859-1");
context.Response.Charset = "UTF-8";
context.Response.ContentType = "text/csv";
context.Response.AppendHeader("Content-Disposition", "attachment; filename=teste.csv");
context.Response.Write("aa\r\nbb\r\nccc");
context.Response.End();