Unit test

WorkdayFunctionTest.java (text/plain), 1.08 KB, created by Artem Bondar on 2016-03-12 20:38:44 UTC

(hide)

Description: Unit test

Filename:

MIME Type:

Creator: Artem Bondar

Created: 2016-03-12 20:38:44 UTC

Size: 1.08 KB

patch

obsolete

>import org.apache.poi.ss.usermodel.Cell; >import org.apache.poi.ss.usermodel.DataFormatter; >import org.apache.poi.ss.usermodel.FormulaEvaluator; >import org.apache.poi.ss.usermodel.Row; >import org.apache.poi.xssf.usermodel.XSSFSheet; >import org.apache.poi.xssf.usermodel.XSSFWorkbook; >import org.junit.Test; > >import java.io.File; >import java.io.FileInputStream; >import java.io.IOException; > >import static org.junit.Assert.assertEquals; > >public class WorkdayFunctionTest { > > @Test > public void testWorkdayFunction() throws IOException { > FileInputStream file = new FileInputStream(new File("WorkDays.xlsx")); > XSSFWorkbook workbook = new XSSFWorkbook(file); > XSSFSheet sheet = workbook.getSheet("Test"); > Row row = sheet.getRow(1); > Cell cell = row.getCell(0); > DataFormatter form = new DataFormatter(); > FormulaEvaluator evaluator = cell.getSheet().getWorkbook().getCreationHelper().createFormulaEvaluator(); > String result = form.formatCellValue(cell, evaluator); > > assertEquals("09 Mar 2016", result); > } >} 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]