public static void ExportReportHeader(string title, NPOI.SS.UserModel.ISheet sheet, StyleContainer allStyles, ref int rowNumber) { var row = sheet.CreateRow(rowNumber++); row.HeightInPoints = 27; var titleCell = row.CreateCell(0); titleCell.SetCellValue(title); titleCell.CellStyle = allStyles.HeaderStyle; titleCell.CellStyle.WrapText = true; var titleMerge = new NPOI.SS.Util.CellRangeAddress(0, 0, 0, 7); sheet.AddMergedRegion(titleMerge); row = sheet.CreateRow(rowNumber++); }