public static void SetStyle(this ExcelStyle Style, styleFourSide side)
{
if (side != null)
{
Style.SetStyle(side.top);
Style.SetStyle(side.bottom);
Style.SetStyle(side.left);
Style.SetStyle(side.right);
}
}
/// <summary>
/// Sets the style.
/// </summary>
/// <param name="ExcelStyle">The excel style.</param>
/// <param name="styleEntry">The style entry.</param>
public static void SetStyle(this ExcelStyle Style, dataTableStyleEntry styleEntry, Boolean isEven = false)
{
Style.Font.SetStyle(styleEntry.Text);
//Style.TextRotation = styleEntry.Text.ro2
if (isEven)
{
Style.Fill.SetStyle(styleEntry.Background);
}
else
{
Style.Fill.SetStyle(styleEntry.BackgroundAlt);
}
Style.SetStyle(styleEntry.Cell);
}
/// <summary>
/// Sets the style.
/// </summary>
/// <param name="Style">The style.</param>
/// <param name="styleEntry">The style entry.</param>
public static void SetStyle(this ExcelStyle Style, styleContainerShot styleEntry)
{
Style.WrapText = styleEntry.doWrapText;
Style.SetStyle(styleEntry.sizeAndBorder);
switch (styleEntry.aligment)
{
case Core.reporting.zone.textCursorZoneCorner.Bottom:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Bottom;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
break;
case textCursorZoneCorner.center:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
break;
case textCursorZoneCorner.default_corner:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
break;
case textCursorZoneCorner.DownLeft:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Bottom;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left;
break;
case textCursorZoneCorner.DownRight:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Bottom;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Right;
break;
case textCursorZoneCorner.Left:
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left;
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
break;
case textCursorZoneCorner.none:
break;
case textCursorZoneCorner.Right:
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Right;
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
break;
case textCursorZoneCorner.Top:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Top;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
break;
case textCursorZoneCorner.UpLeft:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Top;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left;
break;
case textCursorZoneCorner.UpRight:
Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Top;
Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Right;
break;
default:
break;
}
Style.ShrinkToFit = styleEntry.doSizedownContent;
}
