D365_VisualStudio | Excel export line modulation

1. Declare namespace

 

using OfficeOpenXml;
using OfficeOpenXml.Style;

 

2. Import excelRenage 

 

3. Style setting

using(OfficeOpenXml.ExcelPackage package = new OfficeOpenXml.ExcelPackage(templateCopy))
{            
     ExcelWorksheets excelWorksheets  = package.get_Workbook().get_Worksheets();
     ExcelWorksheet  sheet                     = excelWorksheets.get_Item(1);
     sheet.Name                                      = sheetName;
     ExcelRange        cells                      = sheet.get_Cells();
}

cells.get_Style().set_WrapText(true);   //-> 줄바꿈(\n) 처리 가능

 

 

Result