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