예제 #1
0
        public static ExcelCell Left(this ExcelCell @this, int indent)
        {
            @this.Cells().Style.Indent = indent;
            @this.Cells().Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;

            return(@this);
        }
예제 #2
0
 public static ExcelCell Center(this ExcelCell @this)
 {
     @this.Cells().Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
     return(@this);
 }
예제 #3
0
 public static ExcelCell BackgroundColor(this ExcelCell @this, int r, int g, int b)
 {
     @this.Cells().Style.Fill.PatternType = ExcelFillStyle.Solid;
     @this.Cells().Style.Fill.BackgroundColor.SetColor(Color.FromArgb(r, g, b));
     return(@this);
 }
예제 #4
0
 public static ExcelCell Bold(this ExcelCell @this)
 {
     @this.Cells().Style.Font.Bold = true;
     return(@this);
 }
예제 #5
0
 public static ExcelCell FontSize(this ExcelCell @this, int value)
 {
     @this.Cells().Style.Font.Size = value;
     return(@this);
 }
예제 #6
0
 public static ExcelCell BorderTop(this ExcelCell @this, ExcelBorderStyle style, Color color)
 {
     @this.Cells().Style.Border.Top.Style = style;
     @this.Cells().Style.Border.Top.Color.SetColor(color);
     return(@this);
 }
예제 #7
0
 public static ExcelCell FontColor(this ExcelCell @this, int r, int g, int b)
 {
     @this.Cells().Style.Font.Color.SetColor(Color.FromArgb(r, g, b));
     return(@this);
 }
예제 #8
0
 public static ExcelCell Style(this ExcelCell @this, Action <ExcelStyle> action)
 {
     action(@this.Cells().Style);
     return(@this);
 }
예제 #9
0
 public static ExcelCell Numberformat(this ExcelCell @this, string format)
 {
     @this.Cells().Style.Numberformat.Format = format;
     return(@this);
 }
예제 #10
0
 public static ExcelCell Formula(this ExcelCell @this, string value)
 {
     @this.Cells().Formula = value;
     return(@this);
 }
예제 #11
0
 public static ExcelCell Value(this ExcelCell @this, object value)
 {
     @this.Cells().Value = value;
     return(@this);
 }
예제 #12
0
 public static ExcelCell Set(this ExcelCell @this, Action <ExcelRangeBase> action)
 {
     action(@this.Cells());
     return(@this);
 }