Subversion Repositories SmartDukaan

package com.spice.profitmandi.admin.util;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.List;

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import com.spice.profitmandi.dao.entity.catalog.TagRanking;

public class ExcelUtils {

	public static List<TagRanking> parseTagRanking(InputStream inputStream) throws Throwable {

		List<TagRanking> tagRankingList = new ArrayList<>();

		try (XSSFWorkbook myWorkBook = new XSSFWorkbook(inputStream)) {

			myWorkBook.setMissingCellPolicy(MissingCellPolicy.RETURN_BLANK_AS_NULL);

			// Return first sheet from the XLSX workbook

			XSSFSheet mySheet = myWorkBook.getSheetAt(0);

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

				XSSFRow row = mySheet.getRow(rowNumber);

				TagRanking tr = new TagRanking();

				tr.setCatalogItemId(Double.valueOf(row.getCell(0).getNumericCellValue()).intValue());

				tr.setRankPoints(Double.valueOf(row.getCell(0).getNumericCellValue()).intValue());

			}

		}

		return tagRankingList;

	}

}