/// <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); });