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