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();
     }
 }
Exemple #2
0
        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);
        }