public ExcelRange(int rowPosition, ExcelRange range)
{
this.RowStartPosition = rowPosition;
this.ColumnStartPosition = range.ColumnStartPosition;
this.RowEndPosition = rowPosition;
this.ColumnEndPosition = range.ColumnEndPosition;
}
public void AddAlternativeColor(Color alternativeColor)
{
for (int rowIndex = ExcelRange.RowStartPosition; rowIndex <= ExcelRange.RowEndPosition; rowIndex++)
{
var rowRange = new ExcelRange(rowIndex, ExcelRange);
var selectedColor = rowIndex % 2 == 0 ? this.BackgroundColor : alternativeColor;
this.AddBackgroundColor(rowRange.GetRange(this.ExcelSheet), selectedColor);
}
}
public SheetStyle(ExcelRange excelRange, ExcelSheet excelSheet)
{
this.ExcelRange = excelRange;
this.ExcelSheet = excelSheet;
}
