internal ExcelColor(ExcelStyles styles, OfficeOpenXml.XmlHelper.ChangedEventHandler ChangedEvent, int worksheetID, string address, eStyleClass cls, StyleBase parent) :
base(styles, ChangedEvent, worksheetID, address)
{
_parent = parent;
_cls = cls;
}
internal ExcelStyle(ExcelStyles styles, OfficeOpenXml.XmlHelper.ChangedEventHandler ChangedEvent, int PositionID, string Address, int xfsId)
: base(styles, ChangedEvent, PositionID, Address)
{
Index = xfsId;
ExcelXfs xfs = _styles.CellXfs[xfsId];
Numberformat = new ExcelNumberFormat(styles, ChangedEvent, PositionID, Address, xfs.NumberFormatId);
Font = new ExcelFont(styles, ChangedEvent, PositionID, Address, xfs.FontId);
Fill = new ExcelFill(styles, ChangedEvent, PositionID, Address, xfs.FillId);
Border = new Border(styles, ChangedEvent, PositionID, Address, xfs.BorderId);
}
public override OfficeOpenXml.ExcelCellAddress AddItemToWorksheet(OfficeOpenXml.ExcelWorksheet worksheet)
{
int i = Row;
Grid.DataSource = DataSource;
Grid.DataBind();
foreach (WorksheetTableRow row in Grid.Rows)
{
foreach (WorksheetTableDataItem item in row)
{
item.AddItemToWorksheet(worksheet);
}
}
return null;
}
internal Border(ExcelStyles styles, OfficeOpenXml.XmlHelper.ChangedEventHandler ChangedEvent, int PositionID, string address, int index) :
base(styles, ChangedEvent, PositionID, address)
{
Index = index;
}
internal ExcelNumberFormat(ExcelStyles styles, OfficeOpenXml.XmlHelper.ChangedEventHandler ChangedEvent, int PositionID, string Address, int index) :
base(styles, ChangedEvent, PositionID, Address)
{
Index = index;
}
private ExcelCell ResolveCell(EPPlus.ExcelRange native)
{
if (!_cells.ContainsKey(native))
{
_cells.Add(native, new EPPlusExcelCell(native));
}
return _cells[native];
}
/// <summary>
/// Default constructor.
/// </summary>
/// <param name="cell">The native representation of this cell.</param>
public EPPlusExcelCell(EPPlus.ExcelRange cell)
{
_cell = cell;
}
private ExcelSheet ResolveSheet(EPPlus.ExcelWorksheet native)
{
if (!_sheets.ContainsKey(native))
{
_sheets.Add(native, new EPPlusExcelSheet(native));
}
return _sheets[native];
}
/// <summary>
/// Default constructor
/// </summary>
/// <param name="sheet">The XLS sheet to wrap</param>
public EPPlusExcelSheet(EPPlus.ExcelWorksheet sheet)
{
this._sheet = sheet;
}
internal StyleBase(ExcelStyles styles, OfficeOpenXml.XmlHelper.ChangedEventHandler ChangedEvent, int PositionID, string Address)
{
_styles = styles;
_ChangedEvent = ChangedEvent;
_address = Address;
_positionID = PositionID;
}
public OfficeOpenXml.ExcelCellAddress AddItemToWorksheet(OfficeOpenXml.ExcelWorksheet worksheet)
{
throw new NotImplementedException();
}
private void AddBackgroundColor(OfficeOpenXml.ExcelRange range, Color alternativeColor)
{
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
range.Style.Fill.BackgroundColor.SetColor(alternativeColor);
}
private void AddFontWeigth(OfficeOpenXml.ExcelRange range)
{
range.Style.Font.Bold = this.FontBold;
}
private void AddFontColor(OfficeOpenXml.ExcelRange range)
{
range.Style.Font.Color.SetColor(this.FontColor);
}
