public void UpdateWONumbersWithEPPlus(IFormFile file) { DataTable tblContent = GenerateDataTableFromExcel(file); List <WordOrderNumbers> workOrderNumbers = new List <WordOrderNumbers>(); foreach (DataRow tblRow in tblContent.Rows) { WordOrderNumbers workOrderNumber = new WordOrderNumbers() { WorkOrderNumber = tblRow["Work Order Number"].ToString(), SerialNumber = tblRow["Serial Number (Primary Incident Asset Serial Number) (Asset)"].ToString() }; workOrderNumbers.Add(workOrderNumber); } this._context.WordOrderNumber.AddRange(workOrderNumbers); this._context.SaveChanges(); }
/// <summary> /// This method use npoi package to save the file /// </summary> /// <param name="file"></param> public void UpdateWONumbers(IFormFile file) { var stream = file.OpenReadStream(); XSSFWorkbook workBook = new XSSFWorkbook(stream); var excelSheet = workBook.GetSheetAt(0); List <WordOrderNumbers> workOrderNumbers = new List <WordOrderNumbers>(); for (int i = 0; i < excelSheet.LastRowNum; i++) { WordOrderNumbers workOrderNumber = new WordOrderNumbers() { WorkOrderNumber = excelSheet.GetRow(i).GetCell(0).ToString(), SerialNumber = excelSheet.GetRow(i).GetCell(1).ToString() }; workOrderNumbers.Add(workOrderNumber); } this._context.WordOrderNumber.AddRange(workOrderNumbers); this._context.SaveChanges(); }