/// <summary> /// Update the <see cref="CacheItem"/>s. /// </summary> /// <param name="sourceDataRange">The source range of the data without header row.</param> /// <param name="logger">The logger to use to log method calls.</param> public void UpdateRecords(ExcelRangeBase sourceDataRange, IFormulaParserLogger logger) { logger?.LogFunction(nameof(this.UpdateRecords)); // Remove extra records. if (sourceDataRange.Rows < this.Records.Count) { for (int i = this.Records.Count - 1; i >= sourceDataRange.Rows; i--) { this.Records[i].Remove(base.TopNode); } var count = this.Records.Count - sourceDataRange.Rows; if (count > 0) { this.Records.RemoveRange(sourceDataRange.Rows, count); } else { this.Records.RemoveAt(sourceDataRange.Rows); } } for (int row = sourceDataRange.Start.Row; row < sourceDataRange.Rows + sourceDataRange.Start.Row; row++) { int recordIndex = row - sourceDataRange.Start.Row; var rowCells = new List <object>(); int cacheFieldIndex = 0; for (int column = sourceDataRange.Start.Column; column < sourceDataRange.End.Column + 1; column++) { var cacheField = this.CacheDefinition.CacheFields[cacheFieldIndex]; var cell = sourceDataRange.Worksheet.Cells[row, column]; // If the cell value is a DateTime, convert it to an date. if (cacheField.SharedItems.ContainsDate == true && cell.Value is double) { rowCells.Add(DateTime.FromOADate((double)cell.Value)); } else { rowCells.Add(cell.Value); } cacheFieldIndex++; } // If the row is within the existing range of cacheRecords, update that cacheRecord. Otherwise, add a new record. if (recordIndex < this.Records.Count) { this.Records[recordIndex].Update(rowCells, this.CacheDefinition); } else { this.Records.Add(new CacheRecordNode(this.NameSpaceManager, base.TopNode, rowCells, this.CacheDefinition)); } } this.Count = this.Records.Count; }
/// <summary> /// Attaches a logger to the <see cref="FormulaParser"/>. /// </summary> /// <param name="logger">An instance of <see cref="IFormulaParserLogger"/></param> /// <see cref="OfficeOpenXml.FormulaParsing.Logging.LoggerFactory"/> public void AttachLogger(IFormulaParserLogger logger) { _parser.Configure(c => c.AttachLogger(logger)); }
/// <summary> /// Attaches a logger, errors and log entries will be written to the logger during the parsing process. /// </summary> /// <param name="logger"></param> /// <returns></returns> public ParsingConfiguration AttachLogger(IFormulaParserLogger logger) { Require.That(logger).Named("logger").IsNotNull(); Logger = logger; return this; }
/// <summary> /// Attaches a logger, errors and log entries will be written to the logger during the parsing process. /// </summary> /// <param name="logger"></param> /// <returns></returns> public ParsingConfiguration AttachLogger(IFormulaParserLogger logger) { Require.That(logger).Named("logger").IsNotNull(); Logger = logger; return(this); }
/// <summary> /// Attaches a logger to the <see cref="FormulaParser"/>. /// </summary> /// <param name="logger">An instance of <see cref="IFormulaParserLogger"/></param> /// <see cref="OfficeOpenXml.FormulaParsing.Logging.LoggerFactory"/> public void AttachLogger(IFormulaParserLogger logger) { _parser.Configure(c => c.AttachLogger(logger)); }
/// <summary> /// if a logger is attached it will be removed. /// </summary> /// <returns></returns> public ParsingConfiguration DetachLogger() { Logger = null; return(this); }