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;
}