static void Main(string[] args)
{
{
IList <ImportError> errors = new List <ImportError>();
IList <SampleImport> importList;
var filePath = RootDirectoryHelper.GetFilePath("./Excels/sampleImport.xlsx");
var cfgNodeName = "Sample";
using (var fs = new FileStream(filePath, FileMode.Open))
{
importList = new ExcelImportService <SampleImport>().GetParsedPositionImport(fs, errors, cfgNodeName);
}
#region custom
if (errors.Count > 0)
{
LogImportErrors();
}
FilterConflictData(importList, errors);
#endregion
importList.Where(m => !m.IsError).ToList().ForEach(
item => Console.WriteLine(
$"{item.Age} - {item.Name} - {item.Height} - " +
$"{item.GenderName} - {item.Birthday} - {item.Money} - {item.StateName}")
);
Console.Read();
}
}
public ActionResult Index()
{
IList <ImportError> errors = new List <ImportError>();
IList <SampleImport> importList;
var filePath = RootDirectoryHelper.GetFilePath("./Excels/sampleImport.xlsx");
var cfgNodeName = "Sample";
using (var fs = new FileStream(filePath, FileMode.Open))
{
importList = new ExcelImportService <SampleImport>().GetParsedPositionImport(fs, errors, cfgNodeName);
}
//if (errors.Count > 0)
// // handle errors
return(View(importList));
}