public CxColSpec(string col, string title = "", bool nullable = false, CxTipoCol tipoCol = CxTipoCol.General)
{
Col = col;
Nullable = nullable;
Title = title;
TipoColumn = tipoCol;
}
public static IXLCell CLSetColHeader(this IXLWorksheet @this, int row, int col, string name, int width = 10,
CxTipoCol TipoCol = CxTipoCol.General)
{
@this.Column(col).Width = width;
@this.Column(col).Style.NumberFormat.NumberFormatId = (int)TipoCol;
return(@this.Cell(row, col).CLSetColHeader(name, width, TipoCol));
}
public static IXLCell CLSetColHeader(this IXLCell @this, string name, int width = 10,
CxTipoCol TipoCol = CxTipoCol.General)
{
@this.Value = name;
@this.Style.Font.Bold = true;
@this.Style.Border.BottomBorder = XLBorderStyleValues.Thick;
@this.Style.Alignment.SetVertical(XLAlignmentVerticalValues.Center);
@this.Style.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center);
@this.Style.Fill.BackgroundColor = XLColor.DarkCerulean;
@this.Style.Font.FontColor = XLColor.White;
return(@this);
}
public static IXLCell CLSetColHeader(this IXLWorksheet @this, string colRow, string name, int width = 10, CxTipoCol TipoCol = CxTipoCol.General)
{
var col = colRow.Substring(0, 1);
@this.Column(col).Width = width;
@this.Column(col).Style.NumberFormat.NumberFormatId = (int)TipoCol;
return(@this.Cell(colRow).CLSetColHeader(name, width, TipoCol));
}