send.sms.az.util.UploadBlackList.java Source code

Introduction

Here is the source code for send.sms.az.util.UploadBlackList.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package send.sms.az.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.primefaces.model.UploadedFile;
import send.sms.az.model.AddressBook;
import send.sms.az.model.Entry;

public class UploadBlackList {

    private static final Logger logger = Logger.getLogger(UploadBlackList.class.getName());

    public static List<String> readExcelData(UploadedFile fileName) {
        List<Map<String, Entry>> mapList = new ArrayList<>();
        List<String> blList = new ArrayList();
        try {
            InputStream fis = fileName.getInputstream();
            Workbook workbook = null;
            if (fileName.getFileName().toLowerCase().endsWith("xlsx")) {
                workbook = new XSSFWorkbook(fis);
            } else if (fileName.getFileName().toLowerCase().endsWith("xls")) {
                workbook = new HSSFWorkbook(fis);
            }
            //Get the number of sheets in the xlsx file
            int numberOfSheets = workbook.getNumberOfSheets();
            //loop through each of the sheets
            for (int i = 0; i < numberOfSheets; i++) {
                //Get the nth sheet from the workbook
                Sheet sheet = workbook.getSheetAt(i);

                //every sheet has rows, iterate over them
                Iterator<Row> rowIterator = sheet.iterator();
                int rowPos = 0;
                while (rowIterator.hasNext()) {
                    ++rowPos;
                    Map<String, Entry> map = new HashMap<>();//map for full row
                    //Get the row object
                    Row row = rowIterator.next();

                    //Every row has columns, get the column iterator and iterate over them
                    Iterator<Cell> cellIterator = row.cellIterator();
                    int cellPos = 0;//setirsayi
                    while (cellIterator.hasNext()) {
                        //Get the Cell object
                        ++cellPos;
                        Cell cell = cellIterator.next();

                        //check the cell type and process accordingly
                        switch (cell.getCellType()) {
                        case Cell.CELL_TYPE_STRING:
                            String value = cell.getStringCellValue().trim();
                            //                                System.out.println("string " + value + " " + cellPos + " " + rowPos);
                            //                                map.put("" + (cellPos - 1), new Entry("" + rowPos, value));
                            blList.add(value);
                            break;
                        case Cell.CELL_TYPE_NUMERIC:
                            double numValue = cell.getNumericCellValue();
                            //                                System.out.println("numb " + numValue + " " + cellPos + " " + rowPos);
                            //                                map.put("" + (cellPos - 1), new Entry("" + rowPos, "" + numValue));
                            blList.add("" + numValue);
                            break;
                        }
                        break;
                    } //end of cell iterator 
                    mapList.add(map);
                } //end of rows iterator 
                break;
            } //end of sheets for loop 
              //close file input stream
            fis.close();

        } catch (Exception e) {
            blList = new ArrayList<>();
            e.printStackTrace();
        }

        return blList;
    }

}