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 Cells(this ExcelWorksheet @this, int row, int col, int rows = 0, int cols = 0) { var cell = new ExcelCell { Row = row, Col = col, Rows = rows, Cols = cols, Worksheet = @this }; cell.Worksheet.Cells[cell.Row, cell.Col, cell.Row + cell.Rows, cell.Col + cell.Cols].Style.VerticalAlignment = ExcelVerticalAlignment.Center; return(cell); }
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 FontSize(this ExcelCell @this, int value) { @this.Cells().Style.Font.Size = value; return(@this); }
public static ExcelCell Bold(this ExcelCell @this) { @this.Cells().Style.Font.Bold = true; 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 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 Style(this ExcelCell @this, Action <ExcelStyle> action) { action(@this.Cells().Style); return(@this); }
public static ExcelCell Merge(this ExcelCell @this) { @this.Worksheet.Cells[@this.Row, @this.Col, @this.Row + @this.Rows, @this.Col + @this.Cols].Merge = true; 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); }
public static ExcelCell Width(this ExcelCell @this, int value) { @this.Worksheet.Column(@this.Col).Width = value; return(@this); }
public static ExcelCell Column(this ExcelCell @this, Action <ExcelColumn> action) { action(@this.Worksheet.Column(@this.Col)); return(@this); }
public static ExcelCell Height(this ExcelCell @this, int value) { @this.Worksheet.Row(@this.Row).Height = value; return(@this); }
public static ExcelCell Numberformat(this ExcelCell @this, string format) { @this.Cells().Style.Numberformat.Format = format; return(@this); }
public static ExcelCell Center(this ExcelCell @this) { @this.Cells().Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; return(@this); }
public static ExcelRangeBase Cells(this ExcelCell cell) { return(cell.Worksheet.Cells[cell.Row, cell.Col, cell.Row + cell.Rows, cell.Col + cell.Cols]); }