/// <summary>
/// Sets the horizontal alignment of a range.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="horizontalAlignment">The horizontal alignment.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetHorizontalAlignment(
this Range range,
HorizontalAlignment?horizontalAlignment,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (horizontalAlignment != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.HorizontalAlignment = ((HorizontalAlignment)horizontalAlignment).ToTextAlignmentType();
_.StyleFlag.HorizontalAlignment = true;
});
}
}
public static void SetCustomFormat(
this Range range,
string customFormatString,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (customFormatString != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Custom = customFormatString;
_.StyleFlag.NumberFormat = true;
});
}
}
/// <summary>
/// Sets the indent level for a range.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="indentLevel">The indent level.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetIndentLevel(
this Range range,
int?indentLevel,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (indentLevel != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.IndentLevel = (int)indentLevel;
_.StyleFlag.Indent = true;
});
}
}
/// <summary>
/// Sets the rotation angle for a range.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="rotationAngle">The rotation angle.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetFontRotationAngle(
this Range range,
int?rotationAngle,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (rotationAngle != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.RotationAngle = (int)rotationAngle;
_.StyleFlag.Rotation = true;
});
}
}
/// <summary>
/// Sets the text format.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="format">The format.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetFormat(
this Range range,
Format?format,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (format != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Number = ((Format)format).ToFormatNumber();
_.StyleFlag.NumberFormat = true;
});
}
}
/// <summary>
/// Sets text wrapping.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="textIsWrapped">Determines whether text is wrapped.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetTextIsWrapped(
this Range range,
bool?textIsWrapped,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (textIsWrapped != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.IsTextWrapped = (bool)textIsWrapped;
_.StyleFlag.WrapText = true;
});
}
}
/// <summary>
/// Sets underline on the font.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="underlineKind">The kind of underline.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetFontUnderline(
this Range range,
UnderlineKind?underlineKind,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (underlineKind != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Font.Underline = ((UnderlineKind)underlineKind).ToFontUnderlineType();
_.StyleFlag.FontUnderline = true;
});
}
}
/// <summary>
/// Sets bold on the font.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="fontIsBold">Determines whether the font is bold.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetFontIsBold(
this Range range,
bool?fontIsBold,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (fontIsBold != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Font.IsBold = (bool)fontIsBold;
_.StyleFlag.FontBold = true;
});
}
}
/// <summary>
/// Sets the font size for a range.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="fontSize">The font size.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetFontSize(
this Range range,
int?fontSize,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (fontSize != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Font.Size = (int)fontSize;
_.StyleFlag.FontSize = true;
});
}
}
/// <summary>
/// Sets the font name for a range.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="fontName">The font name.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetFontName(
this Range range,
string fontName,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (fontName != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Font.Name = fontName;
_.StyleFlag.FontName = true;
});
}
}
/// <summary>
/// Sets the font color for a range.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="color">The color.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetFontColor(
this Range range,
Color?color,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (color != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Font.Color = (Color)color;
_.StyleFlag.FontColor = true;
});
}
}
/// <summary>
/// Sets the background color of a range.
/// </summary>
/// <param name="range">The range.</param>
/// <param name="color">The color.</param>
/// <param name="styleContainer">The style container.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
public static void SetBackgroundColor(
this Range range,
Color?color,
StyleContainer styleContainer = null)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (color != null)
{
range.SetStyle(styleContainer, _ =>
{
_.Style.Pattern = BackgroundType.Solid;
_.Style.ForegroundColor = (Color)color;
_.StyleFlag.CellShading = true;
});
}
}
/// <summary>
/// Applies the specified range style to the specified range.
/// </summary>
/// <param name="range">The range to apply to the style to.</param>
/// <param name="rangeStyle">The style to apply.</param>
/// <exception cref="ArgumentNullException"><paramref name="range"/> is null.</exception>
/// <exception cref="ArgumentNullException"><paramref name="rangeStyle"/> is null.</exception>
public static void SetRangeStyle(
this Range range,
RangeStyle rangeStyle)
{
if (range == null)
{
throw new ArgumentNullException(nameof(range));
}
if (rangeStyle == null)
{
throw new ArgumentNullException(nameof(rangeStyle));
}
var styleContainer = StyleContainer.BuildNew(range.Worksheet.Workbook);
range.SetBackgroundColor(rangeStyle.BackgroundColor, styleContainer);
range.SetFontColor(rangeStyle.FontColor, styleContainer);
range.SetFontName(rangeStyle.FontName, styleContainer);
range.SetFontSize(rangeStyle.FontSize, styleContainer);
range.SetFontIsItalic(rangeStyle.FontIsItalic, styleContainer);
range.SetFontIsBold(rangeStyle.FontIsBold, styleContainer);
range.SetFontUnderline(rangeStyle.FontUnderline, styleContainer);
range.SetFontRotationAngle(rangeStyle.FontRotationAngle, styleContainer);
range.SetTextIsWrapped(rangeStyle.TextIsWrapped, styleContainer);
range.SetFormat(rangeStyle.Format, styleContainer);
range.SetCustomFormat(rangeStyle.CustomFormatString, styleContainer);
range.SetIndentLevel(rangeStyle.IndentLevel, styleContainer);
range.SetVerticalAlignment(rangeStyle.VerticalAlignment, styleContainer);
range.SetHorizontalAlignment(rangeStyle.HorizontalAlignment, styleContainer);
styleContainer.ApplyToRange(range);
range.SetPerRowHeightInPixels(rangeStyle.RowHeightInPixels);
range.SetPerColumnWidthInPixels(rangeStyle.ColumnWidthInPixels);
range.SetAutofitRows(rangeStyle.AutofitRows);
range.SetMergeCells(rangeStyle.MergeCells);
range.SetInsideBorder(rangeStyle.InsideBorder);
range.SetOutsideBorder(rangeStyle.OutsideBorder);
range.SetDataValidation(rangeStyle.DataValidation);
}