public void SetCellBackground(Guid sheetId, ExcelCell cell, Color color) { var sheet = GetSheet(sheetId); sheet.Cells[cell.Row, cell.Column].Style.Fill.PatternType = ExcelFillStyle.Solid; sheet.Cells[cell.Row, cell.Column].Style.Fill.BackgroundColor.SetColor(color); }
public void CenterInHorizontal(Guid sheetId, ExcelCell cellFrom, ExcelCell cellTo) { var sheet = GetSheet(sheetId); sheet.Cells[cellFrom.Row, cellFrom.Column, cellTo.Row, cellTo.Column].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; }
public void AddValueToCell(Guid sheetId, ExcelCell cell, object value, Color color) { var sheet = GetSheet(sheetId); sheet.Cells[cell.Row, cell.Column].Value = value; SetCellBackground(sheetId, cell, color); }
public void SumCells(Guid sheetId, ExcelCell cell, ExcelCell sumFromCell, ExcelCell sumToCell) { var sheet = GetSheet(sheetId); var fromCellAddress = sheet.Cells[sumFromCell.Row, sumFromCell.Column].Address; var toCellAddress = sheet.Cells[sumToCell.Row, sumToCell.Column].Address; sheet.Cells[cell.Row, cell.Column].Formula = $"SUM({fromCellAddress}:{toCellAddress})"; }
public void MergeCells(Guid sheetId, ExcelCell cellFrom, ExcelCell cellTo) { var sheet = GetSheet(sheetId); sheet.Cells[cellFrom.Row, cellFrom.Column, cellTo.Row, cellTo.Column].Merge = true; }
public void AddValueToCell(Guid sheetId, ExcelCell cell, object value) { var sheet = GetSheet(sheetId); sheet.Cells[cell.Row, cell.Column].Value = value; }