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