I am generating a workbook from HTML. The content of a “td” tag is multi-line text. But while exported as a worksheet the content is shown as a single line text. Can you please suggest me what can be done to display its as a multi-line text.
I have attached the snip of my code, the HTML used to create it and the excel output.Multi-line.zip (76.7 KB)
var loadOptions = new HTMLLoadOptions(LoadFormat.Html)
AutoFitColsAndRows = true
using (var stream = new MemoryStream(Encoding.UTF8.GetBytes(htmlData)))
Workbook wb = new Workbook(stream, loadOptions);
using (var documentStream = new MemoryStream())