public void ExcelRepoCollectsCorrectDataFromExcel(string filePath) { //setup var vv = new FileStream("test.xlsx", FileMode.Open, FileAccess.Read); var excelRepo = new ExcelRepo(vv); //excerise var actual = excelRepo.GetDataFromExcel("SpecialSheetName1"); //assert var expected = new List<List<string>>() { new List<string> { "42" } }; //var expected = new List<object> //{ //new {Id = "Id1", Comment = "FirstEntry", Amount = 100, Date = new DateTime(2016, 1, 18)}, //new {Id = "Id2", Comment = "SecondEntry", Amount = 200, Date = new DateTime(2016, 1, 20)}, //new {Id = "Id3", Comment = "ThirdEntry", Amount = 300.25 , Date = new DateTime(2007, 3, 12)} //}; Assert.Equal(expected,actual); }
public void ExcelRepoCollectsCorrectDataFromExcel(string filePath) { //setup var excelRepo = new ExcelRepo(); //excerise var aa = excelRepo.GetDataFromExcel(); //assert var expected = new List<object> { new {Id = "Id1", Comment = "FirstEntry", Amount = 100, Date = new DateTime(2016, 1, 18)}, new {Id = "Id2", Comment = "SecondEntry", Amount = 200, Date = new DateTime(2016, 1, 20)}, new {Id = "Id3", Comment = "ThirdEntry", Amount = 300.25 , Date = new DateTime(2007, 3, 12)} }; Assert.Equal(expected, aa); }