I am using Epplus library to convert dataTable in excel.I am using text area in my front end site.In which line break is also there.But the problem is when i convert this file to excel, Text is show in one line not in line break.How can I give line break in excel epplus. I am using following script.
using (ExcelPackage pck = new ExcelPackage(newFile))
{
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Accounts");
ws.Cells["A1"].LoadFromDataTable(dataTable, true);
pck.Save();
}
Aucun commentaire:
Enregistrer un commentaire