public void Test()
{
// Arrange
var importer = new ExcelImport <Simple>
{
ColumnMapList = new List <ExcelImport <Simple> .ExcelColumnMap>
{
new ExcelImport <Simple> .ExcelColumnMap(1, (x, value) => x.ColumnA = value),
new ExcelImport <Simple> .ExcelColumnMap(2, (x, value) => x.ColumnB = value),
new ExcelImport <Simple> .ExcelColumnMap(3, (x, value) => x.ColumnC = value)
}
};
// Act
var result = importer.ImportFromFile(FileName, FirstSheetName, 2).ToArray();
// Assert
Assert.AreEqual(2, result.Length);
Assert.AreEqual("Data A", result[0].ColumnA);
Assert.AreEqual("Data B", result[0].ColumnB);
Assert.AreEqual("Data C", result[0].ColumnC);
Assert.AreEqual("Third row", result[1].ColumnA);
Assert.IsNull(result[1].ColumnB);
Assert.AreEqual("Last cell", result[1].ColumnC);
}
