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;
}
