public static ExcelCell Left(this ExcelCell @this, int indent)
{
@this.Cells().Style.Indent = indent;
@this.Cells().Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
return(@this);
}
public static ExcelCell Center(this ExcelCell @this)
{
@this.Cells().Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
return(@this);
}
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);
}
public static ExcelCell Bold(this ExcelCell @this)
{
@this.Cells().Style.Font.Bold = true;
return(@this);
}
public static ExcelCell FontSize(this ExcelCell @this, int value)
{
@this.Cells().Style.Font.Size = value;
return(@this);
}
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);
}
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);
}
public static ExcelCell Style(this ExcelCell @this, Action <ExcelStyle> action)
{
action(@this.Cells().Style);
return(@this);
}
public static ExcelCell Numberformat(this ExcelCell @this, string format)
{
@this.Cells().Style.Numberformat.Format = format;
return(@this);
}
public static ExcelCell Formula(this ExcelCell @this, string value)
{
@this.Cells().Formula = value;
return(@this);
}
public static ExcelCell Value(this ExcelCell @this, object value)
{
@this.Cells().Value = value;
return(@this);
}
public static ExcelCell Set(this ExcelCell @this, Action <ExcelRangeBase> action)
{
action(@this.Cells());
return(@this);
}