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(1).getNumericCellValue()).intValue());
                                tagRankingList.add(tr);
                        }
                }
                return tagRankingList;
        }
}