| public CreateNamedStyle ( string name ) : OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml | ||
| name | string | |
| return | OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml | |
public static ExcelNamedStyleXml MtgPct3(this ExcelStyles styles)
{
var namedStyle = styles.CreateNamedStyle(nameof(MtgPct3));
namedStyle.Style.Numberformat.Format = "#,##0.000%;[Red]-#,##0.000%";
return(namedStyle);
}
public static ExcelNamedStyleXml MtgTableHeader(this ExcelStyles styles)
{
var namedStyle = styles.CreateNamedStyle(nameof(MtgTableHeader));
namedStyle.Style.Fill.SetBackgroundColor(Color.LightBlue, ExcelFillStyle.Solid);
return(namedStyle);
}
public static ExcelNamedStyleXml MtgTableTotals(this ExcelStyles styles)
{
var namedStyle = styles.CreateNamedStyle(nameof(MtgTableTotals));
namedStyle.Style.Fill.SetBackgroundColor(Color.LightBlue, ExcelFillStyle.Solid);
namedStyle.Style.Border.Top.Style = ExcelBorderStyle.Double;
namedStyle.Style.Border.Top.Color.SetColor(Color.LightGray);
return(namedStyle);
}
/// <summary>
/// Creates list of styles.
/// </summary>
/// <param name="styles">The styles.</param>
/// <param name="model">The model.</param>
public static void CreateFromModel(this ExcelStyles styles, XlsxCellStyle model)
{
SentinelHelper.ArgumentNull(styles, nameof(styles));
SentinelHelper.ArgumentNull(model, nameof(model));
try
{
var xlsxStyle = styles.CreateNamedStyle(model.Name);
xlsxStyle.Style.FormatFromModel(model);
var alternateStyleName = $"{model.Name}_Alternate";
xlsxStyle = styles.CreateNamedStyle(alternateStyleName);
xlsxStyle.Style.FormatFromModel(model, true);
}
catch
{
// Already exist.
}
}
/// <summary>
/// Creates list of styles.
/// </summary>
/// <param name="styles">The styles.</param>
/// <param name="model">The model.</param>
public static void CreateFromModel(this ExcelStyles styles, XlsxStylesCollection model)
{
SentinelHelper.ArgumentNull(styles, nameof(styles));
SentinelHelper.ArgumentNull(model, nameof(model));
var defaultStyle = XlsxCellStyle.Default;
var xlsxStyle = styles.CreateNamedStyle(defaultStyle.Name);
xlsxStyle.Style.FormatFromModel(defaultStyle);
var modelStyles = model;
foreach (var style in modelStyles)
{
xlsxStyle = styles.CreateNamedStyle(style.Name);
xlsxStyle.Style.FormatFromModel((XlsxCellStyle)style);
var alternateStyleName = $"{style.Name}_Alternate";
xlsxStyle = styles.CreateNamedStyle(alternateStyleName);
xlsxStyle.Style.FormatFromModel((XlsxCellStyle)style, true);
}
}
/// <summary>
/// Creates list of styles.
/// </summary>
/// <param name="styles">The styles.</param>
/// <param name="model">The model.</param>
public static void CreateFromModel(this ExcelStyles styles, StylesModel model)
{
SentinelHelper.ArgumentNull(styles);
SentinelHelper.ArgumentNull(model);
var defaultStyle = StyleModel.Default;
var xlsxStyle = styles.CreateNamedStyle(defaultStyle.Name);
xlsxStyle.Style.FormatFromModel(defaultStyle);
var modelStyles = model;
foreach (var style in modelStyles)
{
xlsxStyle = styles.CreateNamedStyle(style.Name);
xlsxStyle.Style.FormatFromModel(style);
var alternateStyleName = $"{style.Name}_Alternate";
xlsxStyle = styles.CreateNamedStyle(alternateStyleName);
xlsxStyle.Style.FormatFromModel(style, true);
}
}
public static ExcelNamedStyleXml MtgTable(this ExcelStyles styles)
{
var namedStyle = styles.CreateNamedStyle(nameof(MtgTable));
namedStyle.Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.LightGray);
namedStyle.Style.Border.Left.Style = ExcelBorderStyle.Thin;
namedStyle.Style.Border.Left.Color.SetColor(Color.LightGray);
namedStyle.Style.Border.Top.Style = ExcelBorderStyle.Thin;
namedStyle.Style.Border.Top.Color.SetColor(Color.LightGray);
namedStyle.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
namedStyle.Style.Border.Bottom.Color.SetColor(Color.LightGray);
namedStyle.Style.Border.Right.Style = ExcelBorderStyle.Thin;
namedStyle.Style.Border.Right.Color.SetColor(Color.LightGray);
return(namedStyle);
}
