/// <summary> /// /// </summary> /// <param name="column"></param> /// <param name="start"></param> /// <param name="end"></param> public void Read(int column, int start, int end) { string columnName = ColumnConverter.Get(column); if (this.storedValues.ContainsKey(columnName)) { this.storedValues.Remove(columnName); } if (this.worksheet != null) { Dictionary <int, string> tempDictionary = new Dictionary <int, string>(); for (int i = start; i <= end; i++) { Range range = this.worksheet.Cells[i, column] as Range; string cellValue = range.Value != null?range.Value.ToString() : "null"; tempDictionary.Add(i, cellValue); } this.storedValues.Add(columnName, tempDictionary); } else { this.logger.Error($"The current worksheet seems to be null. Unable to read \"{this.excelPath}\"."); } }
public Cell(int cellColumn, int rowIndex) { this.cellColumn = new Column(ColumnConverter.Get(cellColumn)); this.cellRow = new Row(rowIndex); }