Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getSheetAt

List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook getSheetAt

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFWorkbook
  6. getSheetAt

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getSheetAt.

Prototype

@Override
public XSSFSheet getSheetAt(int index)

Source Link

Document

Get the XSSFSheet object at the given index.

Usage

From source file:com.vertec.daoimpl.AttendanceDAOImpl.java

public String readexcel2(String path) {
    try {/*from  w  ww .j  av  a2  s. c  o m*/
        // Get the workbook instance for XLSX file
        XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(path));

        // Get first sheet from the workbook
        XSSFSheet sheet = wb.getSheetAt(0);

        Row row;
        Cell cell;

        // Iterate through each rows from first sheet
        Iterator<Row> rowIterator = sheet.iterator();

        while (rowIterator.hasNext()) {
            row = rowIterator.next();

            // For each row, iterate through each columns
            Iterator<Cell> cellIterator = row.cellIterator();

            while (cellIterator.hasNext()) {
                cell = cellIterator.next();

                switch (cell.getCellType()) {
                case Cell.CELL_TYPE_STRING:
                    System.out.print(cell.getRichStringCellValue().getString());
                    break;
                case Cell.CELL_TYPE_NUMERIC:
                    if (DateUtil.isCellDateFormatted(cell)) {
                        System.out.print(cell.getDateCellValue());
                    } else {
                        System.out.print(cell.getNumericCellValue());
                    }
                    break;
                case Cell.CELL_TYPE_BOOLEAN:
                    System.out.print(cell.getBooleanCellValue());
                    break;
                case Cell.CELL_TYPE_FORMULA:
                    System.out.print(cell.getCellFormula());
                    break;
                default:
                    System.out.print("");
                }
                System.out.print(" - ");
            }
            System.out.println(";;;");
        }
    } catch (Exception e) {
        System.err.println("Exception :" + e.getMessage());
    }
    return null;
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * import du lieu tu excel/*  www. j  av a2 s .  c  o  m*/
 *
 * @return
 */
public String importFileFromExcel() throws FileNotFoundException, IOException, ParseException {
    List fileInfo = new ArrayList();
    String strReturn = ERROR_PERMISSION;
    //        TechnicalStandard ts = new TechnicalStandard();
    TechnicalStandardDAOHE tshe = new TechnicalStandardDAOHE();
    String err = "";
    Long attachId = Long.parseLong(getRequest().getParameter("attachId"));//get attactId
    VoAttachs att = (VoAttachs) getSession().get("com.viettel.voffice.database.BO.VoAttachs", attachId);//Attachs BO
    if (att == null) {
        fileInfo.add("File not found");
        err += "File not found";
    } else {
        Category item;
        ResourceBundle rb = ResourceBundle.getBundle("config");//get link tuong doi
        String dir = rb.getString("directoryExcel");
        String linkFile = att.getAttachPath();
        linkFile = dir + linkFile;
        createForm.setPath(linkFile);
        InputStream myxls = new FileInputStream(linkFile);//get file excel
        XSSFWorkbook wb = new XSSFWorkbook(myxls);

        XSSFRow row = null;
        String matchingTarget = null;
        XSSFCell productName = null;
        XSSFCell businessTaxCode = null;
        XSSFCell manufactorAddress = null;
        XSSFCell manufactorName = null;
        XSSFCell manufactorTel = null;
        XSSFCell manufactorFax = null;
        XSSFCell manufactorEmail = null;
        XSSFCell nationName = null;
        XSSFCell signer = null;
        XSSFCell assessmentMethod = null;
        XSSFCell annoucementNo = null;

        XSSFCell pushlishDate = null;
        XSSFCell nationCompanyName = null;
        XSSFCell nationCompanyAddress = null;
        try {

            XSSFSheet sheet = wb.getSheetAt(0);
            try {
                //                    XSSFSheet sheet1 = wb.getSheetAt(1);
            } catch (Exception ex) {
                LogUtil.addLog(ex);//binhnt sonar a160901
                //                    log.error(e.getMessage());
                err += "Khng tm thy Sheet Chi tit sn phm, ";
            }

            try {
                //                    XSSFSheet sheet2 = wb.getSheetAt(2);
            } catch (Exception ex) {
                //                    log.error(e.getMessage());
                LogUtil.addLog(ex);//binhnt sonar a160901
                err += "Khng tm thy Sheet Ch tiu cht lng ch yu, ";
            }

            try {
                //                    XSSFSheet sheet3 = wb.getSheetAt(3);
            } catch (Exception ex) {
                LogUtil.addLog(ex);//binhnt sonar a160901
                //                    log.error(e.getMessage());
                err += "Khng tm thy Sheet Ch tiu vi sinh vt, ";
            }

            try {
                //                    XSSFSheet sheet4 = wb.getSheetAt(4);
            } catch (Exception ex) {
                LogUtil.addLog(ex);//binhnt sonar a160901
                //                    log.error(e.getMessage());
                err += "Khng tm thy Sheet Hm lng kim loi nng, ";
            }
            try {
                //                    XSSFSheet sheet5 = wb.getSheetAt(5);
            } catch (Exception ex) {
                LogUtil.addLog(ex);//binhnt sonar a160901
                //                    log.error(e.getMessage());
                err += "Khng tm thy Sheet Hm lng ha cht, ";
            }
            try {
                //                    XSSFSheet sheet6 = wb.getSheetAt(6);
            } catch (Exception ex) {
                LogUtil.addLog(ex);//binhnt sonar a160901
                //                    log.error(e.getMessage());
                err += "Khng tm thy Sheet K hoch kim sot cht lng, ";
            }

            if (sheet == null) {
                err += "Khng tm thy Sheet Bn cng b, ";
            } else {
                String sheetName = sheet.getSheetName();
                if (!"Ban_Cong_bo".equals(sheetName)) {
                    err += "Sai tn sheet Bn cng b, ";
                }
            }

            //                XSSFRow firstRow = sheet.getRow(1);
            int rowNums = sheet.getLastRowNum();
            //                UsersDAOHE sdhe = new UsersDAOHE();
            //                SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
            row = sheet.getRow(1);
            businessTaxCode = row.getCell((short) 1);
            productName = row.getCell((short) 3);
            row = sheet.getRow(4);
            manufactorName = row.getCell((short) 1);
            manufactorAddress = row.getCell((short) 3);
            row = sheet.getRow(5);
            manufactorTel = row.getCell((short) 1);
            manufactorFax = row.getCell((short) 3);
            row = sheet.getRow(6);
            manufactorEmail = row.getCell((short) 1);
            nationName = row.getCell((short) 3);
            row = sheet.getRow(7);
            nationCompanyName = row.getCell((short) 1);
            nationCompanyAddress = row.getCell((short) 3);

            row = sheet.getRow(10);
            annoucementNo = row.getCell((short) 1);
            pushlishDate = row.getCell((short) 3);
            row = sheet.getRow(11);
            signer = row.getCell((short) 1);
            assessmentMethod = row.getCell((short) 3);
            matchingTarget = "";
            String standardCode;
            for (int i = 12; i < rowNums; i++) {
                row = sheet.getRow(i);
                if (row.getCell((short) 1).toString() != "") {
                    XSSFCell standardCodeCell = row.getCell((short) 1);
                    standardCode = standardCodeCell.getRichStringCellValue().toString();
                    if (tshe.findStandardByCode(standardCode)) {
                        XSSFCell matchingTargetCell = row.getCell((short) 2);
                        matchingTarget += matchingTargetCell.getRichStringCellValue() + ";";
                    } else {
                        err += "Quy chun (quy nh) " + standardCode + " khng chnh xc ! ";
                        break;
                    }
                } else {
                    break;
                }
            }

        } catch (Exception ex) {
            LogUtil.addLog(ex);//binhnt sonar a160901
            //                log.error(e.getMessage());
            err += "li tab bn cng b hp quy ";
        }
        if (matchingTarget != "" && matchingTarget != null) {
            matchingTarget = matchingTarget.substring(0, matchingTarget.length() - 1);
        }
        //tab chi tiet san pham
        XSSFCell productNo = null;
        XSSFCell productStatus = null;
        XSSFCell productColor = null;
        XSSFCell productSmell = null;
        XSSFCell productOtherstatus = null;
        XSSFCell productType = null;
        XSSFCell otherTarget = null;
        XSSFCell component = null;
        XSSFCell timeinuse = null;
        XSSFCell useage = null;
        XSSFCell objectInUse = null;
        XSSFCell guideline = null;
        //XSSFCell packageRecipe = null;
        XSSFCell packageMaterial = null;
        XSSFCell productProcess = null;
        XSSFCell counterfeitDistinctive = null;
        XSSFCell origin = null;
        XSSFCell signDate = null;
        XSSFCell signer_productdetails = null;
        XSSFCell chemicalTargetUnwanted = null;
        try {

            XSSFSheet sheet1 = wb.getSheetAt(1);
            if (sheet1 == null) {
                err += "Khng tm thy Sheet Chi tit sn phm, ";

            } else {
                String sheetName = sheet1.getSheetName();
                if (!"Chi_tiet_san_pham".equals(sheetName)) {
                    err += "Sai tn Sheet Chi tit sn phm, ";
                }
            }

            row = sheet1.getRow(1);
            productType = row.getCell((short) 1);
            productNo = row.getCell((short) 3);
            row = sheet1.getRow(4);
            productStatus = row.getCell((short) 1);
            productColor = row.getCell((short) 3);
            row = sheet1.getRow(5);
            productSmell = row.getCell((short) 1);
            productOtherstatus = row.getCell((short) 3);
            row = sheet1.getRow(13);
            otherTarget = row.getCell((short) 1);
            row = sheet1.getRow(14);
            component = row.getCell((short) 1);
            timeinuse = row.getCell((short) 3);
            row = sheet1.getRow(15);
            useage = row.getCell((short) 1);
            objectInUse = row.getCell((short) 3);
            row = sheet1.getRow(16);
            guideline = row.getCell((short) 1);
            packageMaterial = row.getCell((short) 3);
            row = sheet1.getRow(17);
            productProcess = row.getCell((short) 3);
            //packageRecipe = row.getCell((short) 1);
            row = sheet1.getRow(18);
            counterfeitDistinctive = row.getCell((short) 1);
            origin = row.getCell((short) 3);
            row = sheet1.getRow(19);
            signDate = row.getCell((short) 1);
            signer_productdetails = row.getCell((short) 3);
            // bo sung ham luong hoa chat khong mong muon
            XSSFSheet sheet5 = wb.getSheetAt(5);

            int rowNums = sheet5.getLastRowNum();
            do {
                row = sheet5.getRow(rowNums);
                chemicalTargetUnwanted = row.getCell((short) 2);
                rowNums--;
            } while (chemicalTargetUnwanted == null);

            //                chemicalTargetUnwanted = row.getCell((short) 2);
        } catch (Exception ex) {
            LogUtil.addLog(ex);//binhnt sonar a160901
            //                log.error(e.getMessage());
            err += "Li tab chi tit sn phm ";
        }
        // do du lieu vao form
        Long fileId = getRequest().getParameter("fileId") == null ? 0L
                : Long.parseLong(getRequest().getParameter("fileId"));
        Long fileType = getRequest().getParameter("fileType") == null ? 0L
                : Long.parseLong(getRequest().getParameter("fileType"));
        if (fileType > 0L && fileId > 0L) {
            createForm = new FilesForm();
            createForm.setFileType(fileType);
            createForm.setFileId(fileId);
        }
        UsersDAOHE udhe = new UsersDAOHE();
        Users user = udhe.findById(getUserId());

        BusinessDAOHE bdhe = new BusinessDAOHE();
        Business bus = bdhe.findById(user.getBusinessId());

        if (createForm.getFileId() != null && createForm.getFileId() > 0l) {
            FilesDAOHE fdhe = new FilesDAOHE();
            createForm = fdhe.getFilesDetail(createForm.getFileId());
            if (!createForm.getFileType().equals(0L)) {
                ProcedureDAOHE cdhe = new ProcedureDAOHE();
                List lstTTHC = cdhe.getProcedureForChange(createForm.getFileType());
                lstCategory = new ArrayList();
                lstCategory.addAll(lstTTHC);
                lstCategory.add(0,
                        new Procedure(Constants.COMBOBOX_HEADER_VALUE, Constants.COMBOBOX_HEADER_TEXT_SELECT));
                getRequest().setAttribute("lstFileType", lstCategory);

            }
        }

        if (createForm.getFileType() != null && createForm.getFileType() > 0l) {
            ProcedureDAOHE pdhe = new ProcedureDAOHE();
            CategoryDAOHE cdhe = new CategoryDAOHE();
            TechnicalStandardDAOHE tdhe = new TechnicalStandardDAOHE();
            FilesDAOHE fdhe = new FilesDAOHE();
            if (!fileType.equals(0L)) {
                createForm.setFileType(fileType);
            }
            Procedure tthc = pdhe.findById(createForm.getFileType());
            if (tthc != null) {

                lstProductType = cdhe.findAllCategory("SP");
                lstUnit = cdhe.findAllCategory("DVI");

                lstStandard = tdhe.findAllStandard();
                String lstDepts = convertToJSONData(lstStandard, "vietnameseName", "vietnameseName");
                getRequest().setAttribute("lstStandard", lstDepts);

                UserAttachsDAOHE uahe = new UserAttachsDAOHE();
                lstUserAttach = uahe.findAllUserAttach(getUserId());
                String lstUserAttachs = convertToJSONData(lstUserAttach, "attachName", "attachName");
                getRequest().setAttribute("lstUserAttach", lstUserAttachs);
                if (lstUserAttachs.trim().length() > 0) {
                    createForm.setCountUA(1L);
                } else {
                    createForm.setCountUA(0L);
                }
                getRequest().setAttribute("lstProductType", lstProductType);
                getRequest().setAttribute("lstUnit", lstUnit);

                String fileLst = tthc.getFileList();
                getRequest().setAttribute("fileList", com.viettel.common.util.StringUtils.removeHTML(fileLst));
                getRequest().setAttribute("agencyName", getDepartmentName());
                getRequest().setAttribute("fileNameFull", tthc.getName());
                strReturn = tthc.getDescription();
                if (createForm.getAnnouncement() != null) {
                    if (createForm.getAnnouncement().getAnnouncementNo() != null
                            && createForm.getAnnouncement().getAnnouncementNo().length() > 0l) {
                        return strReturn;
                    }
                }
                if (strReturn.equals(Constants.FILE_DESCRIPTION.ANNOUNCEMENT_FILE01)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.ANNOUNCEMENT_FILE03)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_FUNC_IMP)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_FUNC_VN)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_NORMAL_IMP)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_NORMAL_VN)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.REC_CONFIRM_NORMAL_IMP)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.RE_ANNOUNCEMENT)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.RE_CONFIRM_FUNC_IMP)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.RE_CONFIRM_FUNC_VN)
                        || strReturn.equals(Constants.FILE_DESCRIPTION.RE_CONFIRM_NORMAL_VN)) {
                    String announcementNoStr = fdhe.getReceiptNoNew(getUserId(), getUserLogin(),
                            createForm.getFileType());
                    createForm.setAnnouncement(new AnnouncementForm());
                    createForm.getAnnouncement().setAnnouncementNo(announcementNoStr);
                    // thong tin doanh nghiep
                    createForm.getAnnouncement().setBusinessAddress(bus.getBusinessAddress());
                    createForm.getAnnouncement().setBusinessFax(bus.getBusinessFax());
                    createForm.getAnnouncement().setBusinessName(bus.getBusinessName());
                    createForm.getAnnouncement().setBusinessTelephone(bus.getBusinessTelephone());
                    createForm.getAnnouncement().setBusinessEmail(bus.getUserEmail());
                    createForm.getAnnouncement().setBusinessLicence(bus.getBusinessLicense());

                    // ho so cap lai 7-11
                    createForm.setReIssueForm(new ReIssueFormForm());
                    createForm.getReIssueForm().setBusinessName(bus.getBusinessName());
                    createForm.getReIssueForm().setIdentificationNumber(bus.getBusinessLicense());
                    createForm.getReIssueForm().setAddress(bus.getBusinessAddress());
                    createForm.getReIssueForm().setEmail(bus.getUserEmail());
                    createForm.getReIssueForm().setTelephone(bus.getBusinessTelephone());
                    createForm.getReIssueForm().setFax(bus.getBusinessFax());
                    //set thong tin tu excel

                    try {
                        if (businessTaxCode != null && user.getUserName().equals(businessTaxCode.toString())) {
                            if (matchingTarget != "" && matchingTarget != null) {
                                createForm.getAnnouncement().setMatchingTarget(matchingTarget.toString());
                            }
                            createForm.getAnnouncement().setProductName(productName.toString());
                            createForm.getAnnouncement().setManufactureAddress(manufactorAddress.toString());
                            createForm.getAnnouncement().setManufactureName(manufactorName.toString());
                            createForm.getAnnouncement().setManufactureTel(manufactorTel.toString());
                            createForm.getAnnouncement().setManufactureFax(manufactorFax.toString());
                            createForm.getAnnouncement().setManufactureEmail(manufactorEmail.toString());
                            createForm.getAnnouncement().setNationName(nationName.toString());
                            createForm.getAnnouncement().setSigner(signer.toString());
                            createForm.getAnnouncement()
                                    .setNationCompanyAddress(nationCompanyAddress.toString());
                            createForm.getAnnouncement().setNationCompanyName(nationCompanyName.toString());
                            createForm.getAnnouncement().setAssessmentMethod(assessmentMethod.toString());
                            if (pushlishDate.toString() != null && pushlishDate.toString().length() > 0) {
                                createForm.getAnnouncement().setPublishDate(DateTimeUtils
                                        .convertStringToTime(pushlishDate.toString(), "dd/MM/yyyy"));
                            }
                            createForm.getAnnouncement().setAnnouncementNo(annoucementNo.toString());
                            //tab thong tin chi tiet
                            createForm.setDetailProduct(new DetailProductForm());
                            createForm.getDetailProduct().setProductNo(productNo.toString());
                            createForm.getDetailProduct().setProductStatus(productStatus.toString());
                            createForm.getDetailProduct().setProductColor(productColor.toString());
                            createForm.getDetailProduct().setProductSmell(productSmell.toString());
                            createForm.getDetailProduct().setProductOtherStatus(productOtherstatus.toString());

                            item = cdhe.findCategoryByName("SP", productType.toString());
                            if (item != null) {
                                createForm.getDetailProduct().setProductType(item.getCategoryId());
                            } else {
                                err += "Danh mc " + productType.toString() + " khng chnh xc, ";
                            }

                            createForm.getDetailProduct().setOtherTarget(otherTarget.toString());
                            createForm.getDetailProduct().setComponents(component.toString());
                            createForm.getDetailProduct().setTimeInUse(timeinuse.toString());
                            createForm.getDetailProduct().setUseage(useage.toString());
                            createForm.getDetailProduct().setObjectUse(objectInUse.toString());
                            createForm.getDetailProduct().setGuideline(guideline.toString());
                            //createForm.getDetailProduct().setPackageRecipe(packageRecipe.toString());
                            createForm.getDetailProduct().setPackateMaterial(packageMaterial.toString());
                            createForm.getDetailProduct().setProductionProcess(productProcess.toString());
                            createForm.getDetailProduct()
                                    .setCounterfeitDistinctive(counterfeitDistinctive.toString());
                            createForm.getDetailProduct().setOrigin(origin.toString());
                            if (signDate.toString() != null && signDate.toString().length() > 0) {
                                createForm.getDetailProduct().setSignDate(
                                        DateTimeUtils.convertStringToTime(signDate.toString(), "dd/MM/yyyy"));
                            }
                            createForm.getDetailProduct().setSigner(signer_productdetails.toString());
                            createForm.getDetailProduct()
                                    .setChemicalTargetUnwanted(chemicalTargetUnwanted.toString());
                            createForm.setStatusExcel(
                                    err += "Thm mi bn cng b hp quy thnh cng ");
                        } else {
                            createForm.setStatusExcel(err += "M s thu khng chnh xc ");
                        }
                    } catch (Exception ex) {
                        //                            log.error(parseException);
                        LogUtil.addLog(ex);//binhnt sonar a160901
                        createForm.setStatusExcel(
                                err += "Thm mi bn cng b hp quy khng thnh cng ");
                    }
                }
            }
        }
    }
    CategoryDAOHE ctdhe = new CategoryDAOHE();
    Category cate = ctdhe.findCategoryByTypeAndCode("SP", "TPCN");
    Category cateTL = ctdhe.findCategoryByTypeAndCode("SP", "TL");
    List<Category> cate1 = ctdhe.findCategoryByTypeAndCodeNew("SP", "DBT");
    String dbtId = "";
    for (int i = 0; i < cate1.size(); i++) {
        dbtId += cate1.get(i).getCategoryId().toString() + ";";
    }
    Long tpcnId = cate.getCategoryId();
    Long tlId = cateTL.getCategoryId();
    FeeDAOHE fdhe1 = new FeeDAOHE();
    Fee findfee1 = fdhe1.findFeeByCode("TPDB");
    Long priceTPDB = findfee1.getPrice();
    Fee findfee2 = fdhe1.findFeeByCode("TPCN");
    Long priceTPCN = findfee2.getPrice();
    Fee findfee3 = fdhe1.findFeeByCode("TPK");
    Long priceETC = findfee3.getPrice();
    getRequest().setAttribute("dbtId", dbtId);
    getRequest().setAttribute("tpcnId", tpcnId);
    getRequest().setAttribute("tlId", tlId);
    getRequest().setAttribute("priceTPCN", priceTPCN);
    getRequest().setAttribute("priceTPDB", priceTPDB);
    getRequest().setAttribute("priceETC", priceETC);

    return strReturn;
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * load mainly target tu excel// www.  j  a v a2  s. c  o  m
 *
 * @return
 */
public String loadMainlyTargetExcel() throws FileNotFoundException, IOException {
    // mainly target
    Category item = new Category();
    String linkFile = getRequest().getParameter("path");
    String fileError = "";
    List customInfo = new ArrayList();
    InputStream myxls = new FileInputStream(linkFile);//get file excel
    XSSFWorkbook wb = new XSSFWorkbook(myxls);
    List<MainlyTarget> lstMainlyTarget = null;
    try {
        XSSFSheet sheet2 = wb.getSheetAt(2);
        if (sheet2 == null) {
            fileError += "Khng tm thy Sheet Ch tiu cht lng ch yu, ";
        } else {
            String sheetName = sheet2.getSheetName();
            if (!"Chi_tieu_chat_luong_chu_yeu".equals(sheetName)) {
                fileError += "Sai tn Sheet Ch tiu cht lng ch yu, ";
            }
        }

        XSSFRow row;
        int rowNums2 = sheet2.getLastRowNum();
        lstMainlyTarget = new ArrayList<MainlyTarget>();
        CategoryDAOHE cdhed = new CategoryDAOHE();

        for (int i = 2; i < rowNums2; i++) {
            row = sheet2.getRow(i);
            if (row.getCell((short) 1) != null && row.getCell((short) 1).toString().trim() != "") {
                MainlyTarget temp = new MainlyTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell publishLevel = row.getCell((short) 3);
                XSSFCell meetLevel = row.getCell((short) 4);
                item = cdhed.findCategoryByName("DVI", unitId.toString());
                if (item != null) {
                    temp.setMeetLevel(meetLevel.toString());
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setPublishLevel(publishLevel.toString());
                    lstMainlyTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }
        }
        fileError += "Thm mi cc ch tiu cht lng ch yu thnh cng ";
        customInfo.add(fileError);
    } catch (Exception ex) {
        fileError += "Thm mi cc ch tiu cht lng ch yu khng thnh cng ";
        customInfo.add(fileError);
        //            log.error(e.getMessage());
        LogUtil.addLog(ex);//binhnt sonar a160901
    }
    jsonDataGrid.setCustomInfo(customInfo);
    jsonDataGrid.setItems(lstMainlyTarget);
    return GRID_DATA;
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * load product target tu excel//from ww  w. jav a  2s .c om
 *
 * @return
 */
public String loadProductTargetExcel() throws FileNotFoundException, IOException {

    Category item = new Category();
    String linkFile = getRequest().getParameter("path");
    String fileError = "";
    List customInfo = new ArrayList();
    InputStream myxls = new FileInputStream(linkFile);//get file excel
    XSSFWorkbook wb = new XSSFWorkbook(myxls);
    List<ProductTarget> lstProductTarget = null;
    try {
        XSSFSheet sheet3 = wb.getSheetAt(3);
        if (sheet3 == null) {
            fileError += "Khng tm thy Sheet Ch tiu vi sinh vt, ";
        } else {
            String sheetName = sheet3.getSheetName();
            if (!"Chi_tieu_vi_sinh_vat".equals(sheetName)) {
                fileError += "Sai tn Sheet Ch tiu vi sinh vt, ";
            }
        }
        XSSFRow row;
        int rowNums3 = sheet3.getLastRowNum();
        lstProductTarget = new ArrayList<ProductTarget>();
        CategoryDAOHE cdhed = new CategoryDAOHE();
        // vi sinh vat
        for (int i = 2; i < rowNums3; i++) {
            row = sheet3.getRow(i);
            if (row.getCell((short) 1) != null && !"".equals(row.getCell((short) 1).toString().trim())) {
                ProductTarget temp = new ProductTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell maxLevel = row.getCell((short) 3);
                item = cdhed.findCategoryByName("DVI", unitId.toString().trim());
                if (item != null) {
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setMaxLevel(maxLevel.toString());
                    temp.setTargetType(1l);
                    lstProductTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }

        }
        //kim loai nang

        XSSFSheet sheet4 = wb.getSheetAt(4);
        if (sheet4 == null) {
            fileError += "Khng tm thy Sheet Hm lng kim loi nng, ";
        } else {
            String sheetName2 = sheet4.getSheetName();
            if (!"Ham_luong_kim_loai_nang".equals(sheetName2)) {
                fileError += "Sai tn Sheet Hm lng kim loi nng, ";
            }
        }
        int rowNums4 = sheet4.getLastRowNum();
        for (int i = 2; i < rowNums4; i++) {
            row = sheet4.getRow(i);
            if (row.getCell((short) 1) != null && !"".equals(row.getCell((short) 1).toString().trim())) {
                ProductTarget temp = new ProductTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell maxLevel = row.getCell((short) 3);
                item = cdhed.findCategoryByName("DVI", unitId.toString().trim());
                if (item != null) {
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setMaxLevel(maxLevel.toString());
                    temp.setTargetType(2l);
                    lstProductTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }
        }

        //hoa chat khong mong muon
        XSSFSheet sheet5 = wb.getSheetAt(5);
        if (sheet5 == null) {
            fileError += "Khng tm thy Sheet Hm lng ha cht khng mong mun, ";
        } else {
            String sheetName1 = sheet5.getSheetName();

            if (!"Ham_luong_hoa_chat".equals(sheetName1)) {
                fileError += "Sai tn Sheet Hm lng ha cht khng mong mun, ";
            }
        }
        int rowNums5 = sheet5.getLastRowNum();
        for (int i = 2; i < rowNums5; i++) {
            row = sheet5.getRow(i);
            if (row.getCell((short) 1) != null && !"".equals(row.getCell((short) 1).toString().trim())) {
                ProductTarget temp = new ProductTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell maxLevel = row.getCell((short) 3);
                item = cdhed.findCategoryByName("DVI", unitId.toString().trim());
                if (item != null) {
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setMaxLevel(maxLevel.toString());
                    temp.setTargetType(3l);
                    lstProductTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }
        }
        fileError += "Thm mi cc ch tiu vi sinh vt, hm lng kim loi nng, hm lng ha cht khng mong mun thnh cng ";
        customInfo.add(fileError);

    } catch (Exception ex) {
        fileError += "Thm mi cc ch tiu vi sinh vt, hm lng kim loi nng, hm lng ha cht khng mong mun khng thnh cng ";
        customInfo.add(fileError);
        //            log.error(e.getMessage());
        LogUtil.addLog(ex);//binhnt sonar a160901
    }
    jsonDataGrid.setCustomInfo(customInfo);
    jsonDataGrid.setItems(lstProductTarget);
    return GRID_DATA;
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * load quality control plan excel//from www.j  a va  2  s .  c  o m
 *
 * @return
 */
public String loadQualityControlsExcel() throws FileNotFoundException, IOException {
    // mainly target
    //        Category item = new Category();
    String linkFile = getRequest().getParameter("path");
    String fileError = "";
    List customInfo = new ArrayList();
    InputStream myxls = new FileInputStream(linkFile);//get file excel
    XSSFWorkbook wb = new XSSFWorkbook(myxls);
    List<QualityControlPlan> lstQualityControl = null;
    try {
        XSSFSheet sheet6 = wb.getSheetAt(6);
        if (sheet6 == null) {
            fileError += "Khng tm thy Sheet K hoch kim sot, ";
        } else {
            String sheetName1 = sheet6.getSheetName();

            if (!"Ke_Hoach_Kiem_soat".equals(sheetName1)) {
                fileError += "Khng tm thy Sheet K hoch kim sot, ";
            }
        }
        XSSFRow row;
        int rowNums6 = sheet6.getLastRowNum();
        lstQualityControl = new ArrayList<QualityControlPlan>();
        //            CategoryDAOHE cdhed = new CategoryDAOHE();

        for (int i = 2; i < rowNums6; i++) {
            row = sheet6.getRow(i);
            if (row.getCell((short) 1).toString().trim() != "") {
                QualityControlPlan temp = new QualityControlPlan();
                XSSFCell processDetails = row.getCell((short) 1);
                XSSFCell controlTarget = row.getCell((short) 2);
                XSSFCell technicalRegulation = row.getCell((short) 3);
                XSSFCell patternFrequence = row.getCell((short) 4);
                XSSFCell testDevice = row.getCell((short) 5);
                XSSFCell testMethod = row.getCell((short) 6);
                //                    XSSFCell noteForm = row.getCell((short) 7);
                XSSFCell note = row.getCell((short) 8);
                temp.setProductProcessDetail(processDetails.toString());
                temp.setControlTarget(controlTarget.toString());
                temp.setTechnicalRegulation(technicalRegulation.toString());
                temp.setPatternFrequence(patternFrequence.toString());
                temp.setTestDevice(testDevice.toString());
                temp.setTestMethod(testMethod.toString());
                temp.setNote(note.toString());
                temp.setNoteForm(note.toString());
                lstQualityControl.add(temp);
            } else {
                break;
            }

        }
        fileError = "Thm mi k hoch kim sot cht lng thnh cng ";
        customInfo.add(fileError);
    } catch (Exception ex) {
        fileError = "Thm mi k hoch kim sot cht lng khng thnh cng ";
        customInfo.add(fileError);
        //            log.error(e.getMessage());
        LogUtil.addLog(ex);//binhnt sonar a160901
    }

    jsonDataGrid.setCustomInfo(customInfo);
    jsonDataGrid.setItems(lstQualityControl);
    return GRID_DATA;
}

From source file:com.vodafone.poms.ii.helpers.ActivityCodeLoader.java

public static List<ActivityCode> readFile(InputStream fis) {

    List<ActivityCode> activitiesCode = new ArrayList<>();
    ActivityCode activityCode = null;/*from w  ww. j a  v a 2  s .co  m*/
    try {

        XSSFWorkbook myWorkBook = new XSSFWorkbook(fis);
        int numberOfSheets = myWorkBook.getNumberOfSheets();
        XSSFSheet sheet = null;
        System.out.println(numberOfSheets);
        for (int i = 0; i < numberOfSheets; i++) {
            if (myWorkBook.getSheetAt(i).getSheetName().toLowerCase().contains("code")) {
                sheet = myWorkBook.getSheetAt(i);
                break;
            }
        }
        if (sheet != null) {
            Iterator<Row> rowIterator = sheet.iterator();
            while (rowIterator.hasNext()) {
                Row row = rowIterator.next();
                if (getCellValue(row.getCell(0)).length() > 0) {
                    activityCode = new ActivityCode();
                    activityCode.setMaterialId(getCellValue(row.getCell(0)));
                    activityCode.setDescription(getCellValue(row.getCell(1)));
                    if (getCellValue(row.getCell(2)).matches("\\d+(?:\\.\\d+)?")) {
                        activityCode.setQuantityRequested(new Integer(getCellValue(row.getCell(2))));
                    }
                    if (getCellValue(row.getCell(3)).matches("\\d+(?:\\.\\d+)?")) {
                        activityCode.setVendorPrice(new Float(getCellValue(row.getCell(3))));
                    } else {
                        continue;
                    }
                    if (getCellValue(row.getCell(4)).matches("\\d+(?:\\.\\d+)?")) {
                        activityCode.setSubcontractorPrice(new Float(getCellValue(row.getCell(4))));
                    } else {
                        continue;
                    }
                    activityCode.setUm(activityCode.getVendorPrice() - activityCode.getSubcontractorPrice());
                    activityCode.setUmPercent(activityCode.getUm() / activityCode.getVendorPrice());
                    activitiesCode.add(activityCode);
                }
            }
        }

    } catch (FileNotFoundException ex) {
        Logger.getLogger(ActivityCodeLoader.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(ActivityCodeLoader.class.getName()).log(Level.SEVERE, null, ex);
    }

    return activitiesCode;

}

From source file:com.vodafone.poms.ii.helpers.ActivityLoader.java

public void readFile(FileUploadEvent event) {
    if (event.getFile() != null) {
        Activity activity = null;/*  w w w  .j  a v  a 2  s  .  co  m*/
        List<Activity> activities = new ArrayList<>();
        try {

            String errors = "";
            XSSFWorkbook myWorkBook = new XSSFWorkbook(event.getFile().getInputstream());
            int numberOfSheets = myWorkBook.getNumberOfSheets();
            XSSFSheet sheet = null;
            System.out.println(numberOfSheets);
            for (int i = 0; i < numberOfSheets; i++) {
                if (myWorkBook.getSheetAt(i).getSheetName().toLowerCase().contains("rack")) {
                    sheet = myWorkBook.getSheetAt(i);
                    break;
                }
            }

            if (sheet != null) {
                int numOfMergedRegions = sheet.getNumMergedRegions();
                for (int i = 0; i < numOfMergedRegions; i++) {
                    sheet.removeMergedRegion(0);
                }
                Iterator<Row> rowIterator = sheet.iterator();
                if (rowIterator.hasNext()) {
                    rowIterator.next();
                }
                while (rowIterator.hasNext()) {
                    Row row = rowIterator.next();
                    if (getCellValue(row.getCell(0)).length() > 0) {
                        activity = new Activity();
                        Sites site = null;

                        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                        if ((site = sitesController
                                .getSites(getCellValue(row.getCell(0)).toUpperCase())) != null) {
                            activity.setSite(site); // Site
                            activity.setAsp(
                                    subContractorsController.getSubcontractors(getCellValue(row.getCell(1)))); // ASP
                            if (activity.getAsp() == null) {
                                errors += "Row:" + (row.getRowNum() + 1)
                                        + " contains unrecognized ASP: Current Value: "
                                        + getCellValue(row.getCell(1)) + "\n";
                                System.out.println("Row:" + (row.getRowNum() + 1)
                                        + " contains unrecognized ASP: Current Value: "
                                        + getCellValue(row.getCell(1)));
                                continue;
                            }
                            activity.setArea(areaController.getArea(getCellValue(row.getCell(2)))); // Area
                            if (activity.getArea() == null) {
                                errors += "Row:" + (row.getRowNum() + 1)
                                        + " contains unrecognized Area: Current Value: "
                                        + getCellValue(row.getCell(2)) + "\n";
                                System.out.println("Row:" + (row.getRowNum() + 1)
                                        + " contains unrecognized Area: Current Value: "
                                        + getCellValue(row.getCell(2)));
                                continue;
                            }
                            if (vendorOwnerController.getByName(getCellValue(row.getCell(3))) != null) {
                                activity.setVendorOwner(
                                        vendorOwnerController.getByName(getCellValue(row.getCell(3)))); // Owner
                            } else {
                                errors += "Row:" + (row.getRowNum() + 1)
                                        + " contains unrecognized Vendor Owner: Current Value: "
                                        + getCellValue(row.getCell(3)) + "\n";
                                System.out.println("Row:" + (row.getRowNum() + 1)
                                        + " contains unrecognized Vendor Owner: Current Value: "
                                        + getCellValue(row.getCell(3)));
                                continue;
                            }
                            activity.setClaimStatus(
                                    claimStatusController.getClaimStatus(getCellValue(row.getCell(4)))); // Claim
                            activity.setApprovalStatus(
                                    approvalStatusController.getApprovalStatus(getCellValue(row.getCell(5)))); // Approval

                            activity.setActivityType(
                                    domainNamesController.getDomainNames(getCellValue(row.getCell(6)))); // type
                            if (activity.getActivityType() == null) {
                                System.out.println("Row:" + (row.getRowNum() + 1)
                                        + " Activity Type is not recognized, Current Value: "
                                        + getCellValue(row.getCell(6)));
                                errors += "Row:" + (row.getRowNum() + 1)
                                        + " Activity Type is not recognized, Current Value: "
                                        + getCellValue(row.getCell(6)) + "\n";
                                continue;
                            }
                            activity.setPhase(phasesController.getPhases(getCellValue(row.getCell(7)))); // phase
                            if (row.getCell(8).getCellType() == XSSFCell.CELL_TYPE_NUMERIC) {
                                activity.setActivityDate(getDateCellValue(row.getCell(8))); // date
                            } else {
                                System.out.println("Row:" + (row.getRowNum() + 1)
                                        + " Activity date is not recognized, Current Value: "
                                        + getCellValue(row.getCell(8)));
                                errors += "Row:" + (row.getRowNum() + 1)
                                        + " Activity date is not recognized, Current Value: "
                                        + getCellValue(row.getCell(8)) + "\n";
                                continue;
                            }
                            activity.setActivityCode(
                                    activityCodeController.getActivityCode(getCellValue(row.getCell(9)))); // Activity Code

                            activity.setAcDescription(getCellValue(row.getCell(10))); // Claim

                            activity.setActivityDetails(getCellValue(row.getCell(11))); // Claim
                            if (activity.getActivityDetails() == null) {
                                System.out.println("Row:" + (row.getRowNum() + 1)
                                        + " Empty Activity Details/Merged Cells");
                                errors += "Row:" + (row.getRowNum() + 1)
                                        + " Empty Activity Details/Merged Cells" + "\n";
                                continue;
                            }
                            if (activity.getActivityDetails().length() == 0) {
                                activity.setActivityDetails("Regular Activity");
                            }
                            try {
                                activity.setQty(Double.parseDouble(
                                        (getCellValue(row.getCell(12)) != null ? getCellValue(row.getCell(12))
                                                : "0"))); // Qty
                            } catch (NumberFormatException e) {
                                activity.setQty(0);
                            }
                            activity.setAcVendorPrice(Float.parseFloat(
                                    (getCellValue(row.getCell(13)) != null ? getCellValue(row.getCell(13))
                                            : "0"))); // vendor price
                            activity.setTotalPriceVendor(Float.parseFloat(
                                    (getCellValue(row.getCell(14)) != null ? getCellValue(row.getCell(14))
                                            : "0"))); // vendor price
                            activity.setTotalPriceVendorTaxes(Float.parseFloat(
                                    (getCellValue(row.getCell(15)) != null ? getCellValue(row.getCell(15))
                                            : "0"))); // vendor price
                            activity.setAcSubcontractorPrice(Float.parseFloat(
                                    (getCellValue(row.getCell(16)) != null ? getCellValue(row.getCell(16))
                                            : "0"))); // vendor price
                            activity.setTotalPriceAsp(Float.parseFloat(
                                    (getCellValue(row.getCell(17)) != null ? getCellValue(row.getCell(17))
                                            : "0"))); // vendor price
                            activity.setTotalUm(Float.parseFloat(
                                    (getCellValue(row.getCell(18)) != null ? getCellValue(row.getCell(18))
                                            : "0"))); // vendor price
                            activity.setTotalUmPercent(Float.parseFloat(
                                    (getCellValue(row.getCell(19)) != null ? getCellValue(row.getCell(19))
                                            : "0"))); // vendor price
                            activity.setActivityComment(getCellValue(row.getCell(20))); // vendor price
                            activity.setCorrelateTo(getCellValue(row.getCell(21))); // vendor price
                            activity.setSysDate(new Date());
                            activity.setCreator(usersController.getLoggedInUser());
                            activity.setTaxes(13.0);

                            activities.add(activity);
                        } else {
                            System.out.println("Row:" + (row.getRowNum() + 1)
                                    + " Activity Site is not recognized, Current Value: "
                                    + getCellValue(row.getCell(0)));
                            errors += "Row:" + (row.getRowNum() + 1)
                                    + " Activity Site is not recognized, Current Value: "
                                    + getCellValue(row.getCell(0)) + "\n";
                        }
                    }
                }
            }
            if (!testFile) {
                activityController.createMultiple(activities);
            }
            if (errors.length() == 0) {
                setErrors("No Errors Found");
            } else {
                setErrors(errors);
            }

        } catch (FileNotFoundException ex) {
            Logger.getLogger(ActivityLoader.class.getName()).log(Level.SEVERE, null, ex);
        } catch (IOException ex) {
            Logger.getLogger(ActivityLoader.class.getName()).log(Level.SEVERE, null, ex);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
        }

    }
}

From source file:com.vodafone.poms.ii.helpers.SiteLoader.java

public static List<Sites> readFile(InputStream fis) {
    List<Sites> sites = new ArrayList<>();
    Sites site = null;/*from  w  ww . j a v a  2s .com*/
    try {

        XSSFWorkbook myWorkBook = new XSSFWorkbook(fis);
        int numberOfSheets = myWorkBook.getNumberOfSheets();
        XSSFSheet sheet = null;
        System.out.println(numberOfSheets);
        for (int i = 0; i < numberOfSheets; i++) {
            sheet = myWorkBook.getSheetAt(i);
            if (sheet.getRow(0) != null && sheet.getRow(0).getCell(0) != null) {
                if (sheet.getRow(0).getCell(0).getStringCellValue().toLowerCase().contains("site")) {
                    //<editor-fold defaultstate="collapsed" desc="Process Sheet">
                    Iterator<Row> rowIterator = sheet.iterator();
                    while (rowIterator.hasNext()) {
                        Row row = rowIterator.next();
                        if (getCellValue(row.getCell(0)).length() > 0) {
                            site = new Sites();
                            site.setSitePhysical(getCellValue(row.getCell(0)));
                            site.setGfRt(getCellValue(row.getCell(1)));
                            sites.add(site);
                        }
                    }
                    //</editor-fold>
                }
            }
        }
    } catch (FileNotFoundException ex) {
        Logger.getLogger(SiteLoader.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(SiteLoader.class.getName()).log(Level.SEVERE, null, ex);
    }
    return sites;
}

From source file:com.vsquaresystem.safedeals.amenity.AmenityService.java

public Vector read() throws IOException {
    File excelFile = attachmentUtils.getDirectoryByAttachmentType(AttachmentUtils.AttachmentType.LOCATION);
    File[] listofFiles = excelFile.listFiles();
    String fileName = excelFile + "/" + listofFiles[0].getName();

    Vector cellVectorHolder = new Vector();
    int type;//from w ww  .  ja  va  2 s.co m
    try {
        FileInputStream myInput = new FileInputStream(fileName);

        XSSFWorkbook myWorkBook = new XSSFWorkbook(myInput);
        XSSFSheet mySheet = myWorkBook.getSheetAt(0);
        Iterator rowIter = mySheet.rowIterator();
        while (rowIter.hasNext()) {
            XSSFRow myRow = (XSSFRow) rowIter.next();
            Iterator cellIter = myRow.cellIterator();

            List list = new ArrayList();
            while (cellIter.hasNext()) {
                XSSFCell myCell = (XSSFCell) cellIter.next();
                if (myCell != null) {
                    switch (myCell.getCellType()) {
                    case Cell.CELL_TYPE_BOOLEAN:

                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;
                    case Cell.CELL_TYPE_NUMERIC:

                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;
                    case Cell.CELL_TYPE_STRING:

                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;
                    case Cell.CELL_TYPE_BLANK:
                        break;
                    case Cell.CELL_TYPE_ERROR:

                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;

                    case Cell.CELL_TYPE_FORMULA:
                        break;
                    }
                }
            }
            cellVectorHolder.addElement(list);
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return cellVectorHolder;

}

From source file:com.vsquaresystem.safedeals.location.LocationService.java

public Vector read() throws IOException {
    File excelFile = attachmentUtils.getDirectoryByAttachmentType(AttachmentUtils.AttachmentType.LOCATION);
    File[] listofFiles = excelFile.listFiles();
    String fileName = excelFile + "/" + listofFiles[0].getName();
    Vector cellVectorHolder = new Vector();
    int type;//from  w w w .  j a  va  2  s  .  co  m
    try {
        FileInputStream myInput = new FileInputStream(fileName);
        XSSFWorkbook myWorkBook = new XSSFWorkbook(myInput);
        XSSFSheet mySheet = myWorkBook.getSheetAt(0);
        Iterator rowIter = mySheet.rowIterator();
        while (rowIter.hasNext()) {
            XSSFRow myRow = (XSSFRow) rowIter.next();
            Iterator cellIter = myRow.cellIterator();
            List list = new ArrayList();
            while (cellIter.hasNext()) {
                XSSFCell myCell = (XSSFCell) cellIter.next();
                if (myCell != null) {
                    switch (myCell.getCellType()) {
                    case Cell.CELL_TYPE_BOOLEAN:
                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;
                    case Cell.CELL_TYPE_NUMERIC:
                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;
                    case Cell.CELL_TYPE_STRING:
                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;
                    case Cell.CELL_TYPE_BLANK:
                        break;
                    case Cell.CELL_TYPE_ERROR:
                        list.add(new DataFormatter().formatCellValue(myCell));
                        break;
                    case Cell.CELL_TYPE_FORMULA:
                        break;
                    }
                }

            }

            cellVectorHolder.addElement(list);
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return cellVectorHolder;

}