public void FormatCell_DataIsDbNull_RangeReturnedUntouched() { // setup ExcelRange range = _workSheet.Cells[1, 1]; range.Value = "test"; // execute ExcelRange result = _excelRangeFormatter.FormatCell(range, DBNull.Value, null); // assert Assert.AreEqual(range.Value, result.Value); Assert.AreEqual("General", result.Style.Numberformat.Format); }
public void FormatCell_DataTypeIsDateTime_ExcelDefaultFormatIsSetOnRange() { // setup const string dateFormat = "yyyy-MM-dd HH:mm:ss"; _excelRangeFormatter = new ExcelRangeFormatter(dateFormat); ExcelRange range = _workSheet.Cells[1, 1]; // execute ExcelRange result = _excelRangeFormatter.FormatCell(range, DateTime.Now, typeof(DateTime)); // assert Assert.AreEqual(dateFormat, result.Style.Numberformat.Format); }
public override void WriteLine(IDataReader reader, ColumnMetaData[] columnInfo) { if (_excelPackage == null) { throw new InvalidOperationException("Initialise must be called to initialise the report writer"); } for (int i = 0; i < columnInfo.Length; i++) { ExcelRange range = _workSheet.Cells[_rowNum, i + 1]; object cellValue = reader.GetValue(i); Type dataType = reader.GetFieldType(i); _excelRangeFormatter.FormatCell(range, cellValue, dataType); } _rowNum++; }