public ICellStyle Get(CustomCellStyle customCellStyle) { if (!_cache.ContainsKey(customCellStyle)) { _cache[customCellStyle] = Create(customCellStyle); } return(_cache[customCellStyle]); }
private ICellStyle Create(CustomCellStyle customCellStyle) { var cellStyle = _workbook.CreateCellStyle(); switch (customCellStyle) { case (CustomCellStyle.Header): cellStyle.BorderBottom = BorderStyle.Thin; cellStyle.SetFont(HeaderFont); break; case (CustomCellStyle.DateTime): cellStyle.DataFormat = DateFormat; cellStyle.SetFont(DefaultFont); break; case (CustomCellStyle.DateTime_Note): cellStyle.DataFormat = DateFormat; ApplyConditionalStyle(ConditionalStyle.Note, cellStyle); cellStyle.SetFont(DefaultFont); break; case (CustomCellStyle.Double): cellStyle.DataFormat = DoubleFormat; cellStyle.SetFont(DefaultFont); break; case (CustomCellStyle.Double_Note): cellStyle.DataFormat = DoubleFormat; cellStyle.SetFont(DefaultFont); ApplyConditionalStyle(ConditionalStyle.Note, cellStyle); break; case (CustomCellStyle.Note): cellStyle.SetFont(DefaultFont); ApplyConditionalStyle(ConditionalStyle.Note, cellStyle); break; case (CustomCellStyle.LongString): cellStyle.SetFont(DefaultFont); cellStyle.WrapText = true; break; case (CustomCellStyle.LongString_Note): cellStyle.SetFont(DefaultFont); cellStyle.WrapText = true; ApplyConditionalStyle(ConditionalStyle.Note, cellStyle); break; case (CustomCellStyle.Default): cellStyle.SetFont(DefaultFont); break; } return(cellStyle); }
public ICellStyle Get(CustomCellStyle rootCustomCellStyle, ConditionalStyle condStyle) { var s = rootCustomCellStyle.ToString(); if (condStyle != ConditionalStyle.None) { s = string.Format("{0}_{1}", s, condStyle); } var customCellStyle = CustomCellStyle.Default; Enum.TryParse <CustomCellStyle>(s, out customCellStyle); return(Get(customCellStyle)); }