Subversion Repositories SmartDukaan

	public static List<PartnerTargetModel> parseFromExcel(InputStream inputStream) throws Exception {

		List<PartnerTargetModel> partnerTargetModels = new ArrayList<>();

		XSSFWorkbook myWorkBook = null;

		try {

			// FileInputStream fileInputStream = new

			// FileInputStream("/home/ashikali/tag_listing1.xlsx");

			myWorkBook = new XSSFWorkbook(inputStream);

			myWorkBook.setMissingCellPolicy(MissingCellPolicy.RETURN_BLANK_AS_NULL);

			// Return first sheet from the XLSX workbook

			XSSFSheet mySheet = myWorkBook.getSheetAt(0);

			LOGGER.info("rowCellNum {}", mySheet.getLastRowNum());

			for (int rowNumber = 1; rowNumber <= mySheet.getLastRowNum(); rowNumber++) {

				XSSFRow row = mySheet.getRow(rowNumber);

				LOGGER.info("row {}", row);

				PartnerTargetModel partnerTargetModel = new PartnerTargetModel();

				if (row.getCell(0) != null && row.getCell(0).getCellTypeEnum() == CellType.NUMERIC) {

					partnerTargetModel.setFofoId((int) row.getCell(0).getNumericCellValue());

				} else {

					ProfitMandiBusinessException profitMandiBusinessException = new ProfitMandiBusinessException(

							FOFO_ID, row.getCell(0).toString(), "TGLSTNG_VE_1010");

					LOGGER.error("Excel file parse error : ", profitMandiBusinessException);

					throw profitMandiBusinessException;

				}

				if (row.getCell(3) != null && row.getCell(3).getCellTypeEnum() == CellType.NUMERIC) {

					partnerTargetModel.setTargetValue((int) row.getCell(3).getNumericCellValue());

				} else {

					ProfitMandiBusinessException profitMandiBusinessException = new ProfitMandiBusinessException(

							TARGET_VALUE, row.getCell(8), "TGLSTNG_VE_1010");

					LOGGER.error("Excel file parse error : ", profitMandiBusinessException);

					throw profitMandiBusinessException;

				}

				partnerTargetModels.add(partnerTargetModel);

			}

			myWorkBook.close();

		} catch (IOException ioException) {

			ioException.printStackTrace();

			throw new ProfitMandiBusinessException(ProfitMandiConstants.EXCEL_FILE, ioException.getMessage(),

					"EXL_VE_1000");

		} finally {

			if (myWorkBook != null) {

				try {

					myWorkBook.close();

				} catch (IOException e) {

					// TODO Auto-generated catch block

					e.printStackTrace();

				}

			}

		}

		return partnerTargetModels;

	}