public void populatePartsList(ExcelPackage package, List <SparePart> parts) { var sheet = package.Workbook.Worksheets.First(); int rowCount = sheet.Dimension.End.Row; for (int row = 2; row < rowCount; row++) { SparePart sparePart = new SparePart(); sparePart.ItemCode = sheet.Cells[row, 1].Text.Trim(); sparePart.Description = sheet.Cells[row, 2].Text.Trim(); sparePart.Type = sheet.Cells[row, 3].Text.Trim(); sparePart.FCAPrice = sheet.Cells[row, 5].Text.Trim(); sparePart.Export = false; parts.Add(sparePart); } }