private void TryCreateHeaderRow(IXLWorkbook wb, Matrix mat, IXLWorksheet sheet) { if (mat.HasHeaders) { var headers = sheet.Row(1); mat.ColumnsDefinitions.Select((colDef, colNum) => { var cell = headers.Cell(1 + colDef.Index); _formatApplier.ApplyFormatToCell(wb, cell, colDef.HeaderCellFormat); cell.Value = colDef.Label; return(cell); }).ToArray(); } }
private bool TryCreateHeaderRow(IWorkbook wb, Matrix mat, ISheet sheet) { if (mat.HasHeaders) { var headers = sheet.CreateRow(0); var cells = mat.ColumnsDefinitions.Select((colDef, colNum) => { var cell = headers.CreateCell(colNum); _formatApplier.ApplyFormatToCell(wb, cell, colDef.HeaderCellFormat); cell.SetCellValue(colDef.Label); return(cell); }); return(cells.Count() > 0); } return(false); }