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