JUnit test case

CountifTest.java (text/plain), 1.12 KB, created by Maciej on 2012-02-08 15:16:27 UTC

(hide)

Description: JUnit test case

Filename:

MIME Type:

Creator: Maciej

Created: 2012-02-08 15:16:27 UTC

Size: 1.12 KB

patch

obsolete

>package org.apache.poi.hssf.record.formula.functions; > >import static org.junit.Assert.assertEquals; > >import java.io.FileInputStream; >import java.io.FileNotFoundException; >import java.io.IOException; > >import org.apache.poi.hssf.usermodel.HSSFWorkbook; >import org.apache.poi.ss.usermodel.CellValue; >import org.apache.poi.ss.usermodel.FormulaEvaluator; >import org.apache.poi.ss.usermodel.Sheet; >import org.apache.poi.ss.usermodel.Workbook; >import org.junit.Test; > >public class CountifTest { > > @Test > public void testCountif() throws FileNotFoundException, IOException { > final int REF_COL = 4; > final int EVAL_COL = 3; > Workbook workbook = new HSSFWorkbook(new FileInputStream( > "test//resources//countif.xls")); > FormulaEvaluator evaluator = workbook.getCreationHelper() > .createFormulaEvaluator(); > Sheet sheet = workbook.getSheetAt(0); > for (int i = 0; i < 8; i++) { > CellValue expected = evaluator.evaluate(sheet.getRow(i).getCell(REF_COL)); > CellValue actual = evaluator.evaluate(sheet.getRow(i).getCell(EVAL_COL)); > assertEquals(expected.formatAsString(), actual.formatAsString()); > } > } >} View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]