Beispiel #1
0
 public static void GenerateFooterAndRestyling(this IXLWorksheet worksheet, int mergedRow, int totalCells, List <MergeCellModel> mergeCells, IList <int> ignoredColumns)
 {
     worksheet.AlignCenter(totalCells, ignoredColumns);
     // add border bottom for last row
     worksheet.BorderLastRow(mergedRow, totalCells);
     // insert cell for footer
     if (!mergeCells.Any())
     {
         return;
     }
     mergeCells.ForEach(mergeCell =>
     {
         worksheet.GenerateMergeCell(mergedRow + 3, mergeCell);
     });
     // set font-size
     worksheet.Row(mergedRow + 2).Style.Font.FontSize = 13;
     worksheet.Row(mergedRow + 3).Style.Font.FontSize = 13;
 }