Programming C#

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);
}