public void XlsImport1()
{
List <Import1Model> data;
using (var ifile = new XlsImportFile("Data\\XlsImport1.xlsx")) {
var imp = new Importer <Import1Model>(ifile);
data = imp.Import().ToList();
}
var expectedData = new Import1Model[] {
new Import1Model {
SVal = "abcde", IVal = 1, FVal = 1.5f, DVal = 2.0000001d, DecVal = 3.4m
},
new Import1Model {
SVal = "xyz,abc", IVal = 2, FVal = 3, DVal = 2, DecVal = 5
},
new Import1Model {
SVal = "", IVal = 0, FVal = 0, DVal = 0, DecVal = 0
},
new Import1Model {
SVal = "a\r\nb", IVal = 0, FVal = 1, DVal = 2, DecVal = 3
}
}.ToList();
CollectionAssert.AreEqual(expectedData, data);
}
public bool Equals(Import1Model other)
{
return(((string.IsNullOrEmpty(SVal) && string.IsNullOrEmpty(other.SVal)) || SVal == other.SVal) && IVal == other.IVal && FVal == other.FVal && DVal == other.DVal && DecVal == other.DecVal);
}
