Example usage for org.apache.poi.hssf.record BoolErrRecord getBooleanValue

Introduction

In this page you can find the example usage for org.apache.poi.hssf.record BoolErrRecord getBooleanValue.

Prototype

public boolean getBooleanValue() 

Source Link

Document

get the value for the cell

Usage

From source file:org.jreserve.gui.poi.read.xls.XlsTableReader.java

License:Open Source License

private void cellRecord(int row, short column, Record record) throws Exception {
    try {// w w  w .j a va  2 s .  c o  m
        //Not on the good sheet, before first row/column
        if (!onReferencedSheet || firstRow > row || firstColumn > column)
            return;

        //The cell is empty, do not read it
        boolean isEmptyCell = isEmpty(record);
        if (isEmptyCell) {
            //If first cell is empty, whole table is empty
            if (firstRow == row && firstColumn == column)
                lastColumn = (short) (firstColumn - 1);
            return;
        }

        //Calculate the last column, based on the first row
        if (firstRow == row) {
            //If we missed a cell, do not read other columns
            if ((column - lastColumn) < 2)
                lastColumn = column;
        }

        //after the last column
        if (column > lastColumn)
            return;

        if (column == firstColumn)
            prevColumn = firstColumn;

        //missed a row, do not read further
        if ((row - prevRow) > 1 || (column - prevColumn) > 1)
            return;

        short sid = record.getSid();
        switch (sid) {
        case NumberRecord.sid:
            factory.numberFound(row, column, ((NumberRecord) record).getValue());
            break;
        case LabelSSTRecord.sid:
            if (sstRecord == null)
                throw new IllegalArgumentException("SSTRecord is null");
            int stringId = ((LabelSSTRecord) record).getSSTIndex();
            String str = sstRecord.getString(stringId).getString();
            factory.stringFound(row, column, str);
            break;
        case LabelRecord.sid:
            factory.stringFound(row, column, ((LabelRecord) record).getValue());
            break;
        case StringRecord.sid:
            factory.stringFound(row, column, ((StringRecord) record).getString());
            break;
        case FormulaRecord.sid:
            FormulaRecord fr = (FormulaRecord) record;
            if (fr.hasCachedResultString()) {
                outputNextString = true;
            } else {
                factory.numberFound(row, column, fr.getValue());
            }
            break;
        case BoolErrRecord.sid:
            BoolErrRecord ber = (BoolErrRecord) record;
            if (ber.isBoolean()) {
                factory.booleanFound(row, column, ber.getBooleanValue());
            } else {
                factory.errorFound(row, column, getErrorMsg(ber.getErrorValue()));
            }
            break;
        default:
            break;
        }

        prevRow = row;
        prevColumn = column;
    } catch (Exception ex) {
        CellReference ref = new CellReference(sheetName, row, column, false, false);
        throw new ExcelReadException(ref, ex);
    }
}

---