public void ExcelRangeFormatterTest_SetUp()
{
_excelRangeFormatter = new ExcelRangeFormatter(null);
_excelPackage = new ExcelPackage();
_workSheet = _excelPackage.Workbook.Worksheets.Add("Data");
}
public void ExcelReportWriterTest_SetUp()
{
// create the root folder
_testRootFolder = Path.Combine(TestUtility.TestRootFolder, "ExcelReportWriterTest");
Directory.CreateDirectory(_testRootFolder);
_excelRangeFormatter = Substitute.For <IExcelRangeFormatter>();
_excelRangeFormatter.When(x => x.FormatCell(Arg.Any <ExcelRange>(), Arg.Any <object>(), Arg.Any <Type>())).Do((r) =>
{
ExcelRange range = r.ArgAt <ExcelRange>(0);
range.Value = r.ArgAt <object>(1);
});
_filePath = Path.Combine(_testRootFolder, Path.GetFileNameWithoutExtension(Path.GetRandomFileName()) + ".xlsx");
_reportWriter = new ExcelReportWriter(_excelRangeFormatter);
}
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 ExcelReportWriter(IExcelRangeFormatter excelRangeFormatter)
{
_excelRangeFormatter = excelRangeFormatter;
}
