Net Core Read Excel
Add Package
dotnet add package NPOI
Read Excel
[HttpPost]
public IActionResult Excel(IFormFile f){
using IWorkbook workbook = WorkbookFactory.Create(f.OpenReadStream());
ISheet sheet = workbook.GetSheetAt(0);
List<Category> list = new List<Category>();
for(int i = 1; i <= sheet.LastRowNum; i++){
IRow row = sheet.GetRow(i);
list.Add(new Category{
CategoryId = Convert.ToByte(row.GetCell(0).NumericCellValue),
CategoryName = row.GetCell(1).StringCellValue
});
}
return View(list);
}