Hi, I am changing code from using a htmlTextWriter to generate an excel document(2010) from a dataset to using the OfficeOpenXML object. The old code had a pipe-delimited string that had the pipes replaced to put in a <br> tag. This produced a line break in a single cell (like using alt+enter). I am trying to do the same thing using the OpenOfficeXML ExcelStyle objects, but I am struggling. Does anyone know how to do this? I tried Char(10), Char(13), \r, \n, etc...Nothing works so far..
I want to do something like this:
cell.Value = value.ToString().Replace("|", "<Br>");