public async Task <IActionResult> UploadFile(IFormFile uploadedFile) { if (uploadedFile.IsFileValid()) { return(Content("File Not Selected")); } string fileExtension = Path.GetExtension(uploadedFile.FileName); if (fileExtension == ".xls" || fileExtension == ".xlsx") { var rootFolder = $"{Directory.GetCurrentDirectory()}\\wwwroot\\Files"; var fileLocation = await uploadedFile.GetFileLocationAndSaveFile(rootFolder); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; using (ExcelPackage package = new ExcelPackage(fileLocation)) { ExcelWorksheet workSheet = package.Workbook.Worksheets[0]; int totalRows = workSheet.Dimension.Rows; List <ProductList> productList = new List <ProductList>(); Guid batch_guid = Guid.NewGuid(); for (int i = 2; i <= totalRows; i++) { productList.Add(new ProductList { ID_BATCH_GUID = batch_guid.ToString(), TX_JAN = workSheet.Cells[i, 1].Value != null ? workSheet.Cells[i, 1].Value.ToString() : string.Empty, TX_SKU = workSheet.Cells[i, 2].Value != null ? workSheet.Cells[i, 2].Value.ToString() : string.Empty, TX_CATEGORY = workSheet.Cells[i, 3].Value != null ? workSheet.Cells[i, 3].Value.ToString() : string.Empty, TX_SUBCATEGORY = workSheet.Cells[i, 4].Value != null ? workSheet.Cells[i, 4].Value.ToString() : string.Empty, TX_INGREDIENTS = workSheet.Cells[i, 5].Value != null ? workSheet.Cells[i, 5].Value.ToString() : string.Empty, DT_UPLOADED = DateTime.Now }); } List <CommonItems> commonItems = await this._commonItemsRepo.GetAll(this._appDBContext); List <PermittedAdditive> permittedAdditives = await this._permittedAdditivesRepo.GetAll(this._appDBContext); BusinessFacade bf = new BusinessFacade(); bf.ProcessUploadedFile(productList, commonItems, permittedAdditives); if (await this._productRepo.Save(this._appDBContext, productList)) { MemoryStream stream = new MemoryStream(); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; using (ExcelPackage pck = new ExcelPackage(stream)) { List <object[]> test = new List <object[]>() { new object[] { "eleaz", "pogi" }, new object[] { "mead", "ganda" }, }; ExcelWorksheet ws = pck.Workbook.Worksheets.Add("MainView"); ws.Cells["A1"].LoadFromArrays(test); var bytes = pck.GetAsByteArray(); return(File(bytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "ExportFile.xlsx")); } } } } return(BadRequest()); }