Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.CellValue

295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
   */
  private CellValue evaluateFormulaCellValue(Cell cell) {
    ValueEval eval = _bookEvaluator.evaluate(new HSSFEvaluationCell((HSSFCell)cell));
    if (eval instanceof NumberEval) {
      NumberEval ne = (NumberEval) eval;
      return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof BoolEval) {
      BoolEval be = (BoolEval) eval;
      return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof StringEval) {
      StringEval ne = (StringEval) eval;
      return new CellValue(ne.getStringValue());
    }
    if (eval instanceof ErrorEval) {
      return CellValue.getError(((ErrorEval)eval).getErrorCode());
    }
    throw new RuntimeException("Unexpected eval class (" + eval.getClass().getName() + ")");
View Full Code Here
35
36
37
38
39
40
41
42
43
  public void testEvaluateSimple() {
    HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFSheet sheet = wb.getSheetAt(0);
    HSSFCell cell = sheet.getRow(8).getCell(0);
    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
    CellValue cv = fe.evaluate(cell);
    assertEquals(HSSFCell.CELL_TYPE_NUMERIC, cv.getCellType());
    assertEquals(3.72, cv.getNumberValue(), 0.0);
  }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
    // were 4 and 1, this would represent a circular reference.  Prior to v3.2 POI would
    // 'fully' evaluate ref arguments before invoking operators, which raised the possibility of
    // cycles / StackOverflowErrors.
   

    CellValue cellValue = evaluateWithCycles(wb, testCell);
   
    assertTrue(cellValue.getCellType() == HSSFCell.CELL_TYPE_NUMERIC);
    assertEquals(2, cellValue.getNumberValue(), 0);
  }
View Full Code Here
92
93
94
95
96
97
98
99
100
   
    HSSFRow row = sheet.createRow(0);
    HSSFCell testCell = row.createCell(0);
    testCell.setCellFormula("A1");

    CellValue cellValue = evaluateWithCycles(wb, testCell);
   
    confirmCycleErrorCode(cellValue);
  }
View Full Code Here
112
113
114
115
116
117
118
119
120
    row.createCell(1).setCellFormula("C1");
    row.createCell(2).setCellFormula("D1");
    HSSFCell testCell = row.createCell(3);
    testCell.setCellFormula("A1");

    CellValue cellValue = evaluateWithCycles(wb, testCell);
   
    confirmCycleErrorCode(cellValue);
  }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
      case XSSFCell.CELL_TYPE_ERROR:
        return CellValue.getError(cell.getErrorCellValue());
      case XSSFCell.CELL_TYPE_FORMULA:
        return evaluateFormulaCellValue(cell);
      case XSSFCell.CELL_TYPE_NUMERIC:
        return new CellValue(cell.getNumericCellValue());
      case XSSFCell.CELL_TYPE_STRING:
        return new CellValue(cell.getRichStringCellValue().getString());
    }
    throw new IllegalStateException("Bad cell type (" + cell.getCellType() + ")");
  }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
   */
  public int evaluateFormulaCell(Cell cell) {
    if (cell == null || cell.getCellType() != XSSFCell.CELL_TYPE_FORMULA) {
      return -1;
    }
    CellValue cv = evaluateFormulaCellValue(cell);
    // cell remains a formula cell, but the cached value is changed
    setCellValue(cell, cv);
    return cv.getCellType();
  }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
    if (cell == null) {
      return null;
    }
    XSSFCell result = (XSSFCell) cell;
    if (cell.getCellType() == XSSFCell.CELL_TYPE_FORMULA) {
      CellValue cv = evaluateFormulaCellValue(cell);
      setCellType(cell, cv); // cell will no longer be a formula cell
      setCellValue(cell, cv);
    }
    return result;
  }
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
   */
  private CellValue evaluateFormulaCellValue(Cell cell) {
    ValueEval eval = _bookEvaluator.evaluate(new XSSFEvaluationCell((XSSFCell) cell));
    if (eval instanceof NumberEval) {
      NumberEval ne = (NumberEval) eval;
      return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof BoolEval) {
      BoolEval be = (BoolEval) eval;
      return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof StringEval) {
      StringEval ne = (StringEval) eval;
      return new CellValue(ne.getStringValue());
    }
    if (eval instanceof ErrorEval) {
      return CellValue.getError(((ErrorEval)eval).getErrorCode());
    }
    throw new RuntimeException("Unexpected eval class (" + eval.getClass().getName() + ")");
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
      }
      if(isIgnoredFormulaTestCase(c.getCellFormula())) {
        continue;
      }

      CellValue actualValue;
      try {
        actualValue = evaluator.evaluate(c);
      } catch (RuntimeException e) {
        _evaluationFailureCount ++;
        printShortStackTrace(System.err, e);
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.CellValue

  • loxia.support.excel.impl.DefaultExcelReader
  • org.apache.poi.hssf.model.TestFormulaParserEval
  • org.apache.poi.hssf.record.formula.eval.TestCircularReferences
  • org.apache.poi.hssf.record.formula.eval.TestExternalFunction
  • org.apache.poi.hssf.record.formula.eval.TestFormulaBugs
  • org.apache.poi.hssf.record.formula.eval.TestFormulasFromSpreadsheet
  • org.apache.poi.hssf.record.formula.eval.TestMissingArgEval
  • org.apache.poi.hssf.record.formula.eval.TestPercentEval
  • org.apache.poi.hssf.record.formula.eval.TestRangeEval
  • org.apache.poi.hssf.record.formula.functions.TestCountFuncs
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.