/// <summary>
/// 设置区域样式，边框及字体
/// </summary>
/// <param name="range">要设置的区域</param>
/// <param name="templateCell">设置单元格模板样式，如果为空则采用默认配置</param>
public static void SetDefaultStyle(
this Range rangeC3E6,
Color?backgroundColor = null,
bool isColumnHeader = false,
SpreadsheetHorizontalAlignment horizontal = SpreadsheetHorizontalAlignment.Center)
{
// Format the "C3:E6" range of cells.
// Access an object representing a range of cells to be formatted.
//Range rangeC3E6 = worksheet.Range["C3:E6"];
// Start updating a range formatting.
Formatting rangeC3E6Formatting = rangeC3E6.BeginUpdateFormatting();
// Specify font appearance (font name, color, size and style).
rangeC3E6Formatting.Font.Name = SpreadSheetConfig.FontName;
//rangeC3E6Formatting.Font.Color = Color.Blue;
rangeC3E6Formatting.Font.Size = SpreadSheetConfig.FontSize;
rangeC3E6Formatting.Font.Bold = false;
// border
rangeC3E6Formatting.Borders.SetAllBorders(
isColumnHeader ? SpreadSheetConfig.HeaderBorderColor : SpreadSheetConfig.ContentBorderColor,
BorderLineStyle.Thin);
// Specify cell background color.
rangeC3E6Formatting.Fill.BackgroundColor = backgroundColor ?? Color.Transparent;
// Specify text alignment in cells.
rangeC3E6Formatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
rangeC3E6Formatting.Alignment.Horizontal = horizontal;
// Complete updating range formatting.
rangeC3E6.EndUpdateFormatting(rangeC3E6Formatting);
}
public static HorizontalAlignment Map(SpreadsheetHorizontalAlignment alignment)
{
return(alignment switch
{
SpreadsheetHorizontalAlignment.Left => HorizontalAlignment.Left,
SpreadsheetHorizontalAlignment.Center => HorizontalAlignment.Center,
SpreadsheetHorizontalAlignment.Right => HorizontalAlignment.Right,
_ => SpreadsheetLibraryDefaults.HorizontalAlignment
});
public IRangeWrapper SetHorizontalAlignment(SpreadsheetHorizontalAlignment alignment)
{
_range.Style.HorizontalAlignment = SpreadsheetHorizontalAlignmentMapper.MapStyle(alignment);
return(this);
}
public static WorksheetContext SetHorizontalAlignment(this WorksheetContext instance, SpreadsheetHorizontalAlignment alignment) => instance.WrapOperation(() =>
{
instance.CurrentRange.SetHorizontalAlignment(alignment);
});