Example usage for org.apache.poi.xssf.usermodel XSSFCell getCellTypeEnum

Introduction

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

Prototype

@Deprecated
@Removal(version = "4.2")
@Override
public final CellType getCellTypeEnum() 

Source Link

Usage

From source file:nc.noumea.mairie.appock.util.StockSpreadsheetImporter.java

License:Open Source License

private static void traiterLigne(int ligne, XSSFSheet worksheet, Service service, StockService stockService)
        throws ImportExcelException {
    XSSFCell referenceCell = worksheet.getRow(ligne).getCell(1);
    if (StringUtils.isBlank(referenceCell.getRawValue())) {
        throw new ImportExcelException(ligne + 1, "La rfrence est introuvable");
    }/*from  w w  w .  java 2  s.  co  m*/
    String reference = referenceCell.getStringCellValue();

    XSSFCell stockReelCell = worksheet.getRow(ligne).getCell(4);
    if (StringUtils.isBlank(stockReelCell.getRawValue())) {
        throw new ImportExcelException(ligne + 1, reference, "La quantit relle n'est pas renseigne");
    }

    if (stockReelCell.getCellTypeEnum() != CellType.NUMERIC) {
        throw new ImportExcelException(ligne + 1, reference, "La cellule 'Stock rl' n'est pas un entier");
    }
    double value = stockReelCell.getNumericCellValue();
    int stockReel = (int) value;
    if (value != stockReel) {
        throw new ImportExcelException(ligne + 1, reference, "La cellule 'Stock rl' n'est pas un entier");
    }
    updateStock(service, reference, stockReel, stockService, ligne);
}

---

From source file:offishell.excel.Excel.java

License:MIT License

/**
 * <p>//from  ww  w .  j  a  va 2 s .c o m
 * ??????????
 * </p>
 * 
 * @param cellName ??
 * @return
 */
public Signal<Row> takeBy(String cellName) {
    int index = indexOfHeader(cellName);

    return new Signal<Row>((observer, disposer) -> {
        for (int i = 1; i < sheet.getLastRowNum(); i++) {
            XSSFRow row = sheet.getRow(i);

            if (row != null) {
                XSSFCell cell = row.getCell(index);

                if (cell != null) {
                    switch (cell.getCellTypeEnum()) {
                    case BLANK:
                        break;

                    case STRING:
                        String value = cell.getStringCellValue();

                        if (value != null && !value.isEmpty()) {
                            observer.accept(new Row(row));
                        }
                        break;

                    default:
                        observer.accept(new Row(row));
                        break;
                    }
                }
            }
        }
        return disposer;
    });
}

---

From source file:org.talend.dataprep.qa.util.ExcelComparator.java

License:Open Source License

public static boolean compareTwoCells(XSSFCell cell1, XSSFCell cell2) {
    if ((cell1 == null) && (cell2 == null)) {
        return true;
    } else if ((cell1 == null) || (cell2 == null)) {
        return false;
    }/*from   w ww.j  a v  a 2 s .  c om*/

    boolean equalCells = false;
    int type1 = cell1.getCellTypeEnum().getCode();
    int type2 = cell2.getCellTypeEnum().getCode();
    if (type1 == type2) {
        if (cell1.getCellStyle().equals(cell2.getCellStyle())) {
            // Compare cells based on its type
            switch (cell1.getCellTypeEnum().getCode()) {
            case HSSFCell.CELL_TYPE_FORMULA:
                if (cell1.getCellFormula().equals(cell2.getCellFormula())) {
                    equalCells = true;
                }
                break;
            case HSSFCell.CELL_TYPE_NUMERIC:
                if (cell1.getNumericCellValue() == cell2.getNumericCellValue()) {
                    equalCells = true;
                }
                break;
            case HSSFCell.CELL_TYPE_STRING:
                if (cell1.getStringCellValue().equals(cell2.getStringCellValue())) {
                    equalCells = true;
                }
                break;
            case HSSFCell.CELL_TYPE_BLANK:
                if (cell2.getCellType() == HSSFCell.CELL_TYPE_BLANK) {
                    equalCells = true;
                }
                break;
            case HSSFCell.CELL_TYPE_BOOLEAN:
                if (cell1.getBooleanCellValue() == cell2.getBooleanCellValue()) {
                    equalCells = true;
                }
                break;
            case HSSFCell.CELL_TYPE_ERROR:
                if (cell1.getErrorCellValue() == cell2.getErrorCellValue()) {
                    equalCells = true;
                }
                break;
            default:
                if (cell1.getStringCellValue().equals(cell2.getStringCellValue())) {
                    equalCells = true;
                }
                break;
            }
        } else {
            return false;
        }
    } else {
        return false;
    }
    return equalCells;
}

---

From source file:ReadExcel.HSSFReadWrite.java

License:Apache License

private static void startReadXlsxFile(String fileName) {
    try {//from  w  ww .ja v  a  2 s  .c o m
        XSSFWorkbook wb = HSSFReadWrite.readxlsxFile(fileName);
        System.out.println("Data dump:\n");
        for (int k = 0; k < wb.getNumberOfSheets(); k++) {
            XSSFSheet sheet = wb.getSheetAt(k);
            int rows = sheet.getPhysicalNumberOfRows();
            System.out.println("Sheet " + k + " \"" + wb.getSheetName(k) + "\" has " + rows + " row(s).");
            for (int r = 0; r < rows; r++) {
                XSSFRow row = sheet.getRow(r);
                if (row == null) {
                    continue;
                }
                int cells = row.getPhysicalNumberOfCells();
                System.out.println("\nROW " + row.getRowNum() + " has " + cells + " cell(s).");
                for (int c = 0; c < cells; c++) {
                    XSSFCell cell = row.getCell(c);
                    String value = null;
                    switch (cell.getCellTypeEnum()) {
                    case FORMULA:
                        value = "FORMULA value=" + cell.getCellFormula();
                        break;
                    case NUMERIC:
                        value = "NUMERIC value=" + cell.getNumericCellValue();
                        break;
                    case STRING:
                        value = "STRING value=" + cell.getStringCellValue();
                        break;
                    default:
                    }
                    System.out.println("CELL col=" + cell.getColumnIndex() + " VALUE=" + value);
                }
            }
        }
        wb.close();

    } catch (Exception e) {
        e.printStackTrace();
    }
}

---