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