poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cen...@apache.org
Subject svn commit: r1538281 - /poi/trunk/src/excelant/testcases/org/apache/poi/ss/excelant/util/TestExcelAntWorkbookUtil.java
Date Sat, 02 Nov 2013 20:58:22 GMT
Author: centic
Date: Sat Nov  2 20:58:22 2013
New Revision: 1538281

URL: http://svn.apache.org/r1538281
Log:
Add slightly more coverage for ExcelAntWorkbookUtil

Modified:
    poi/trunk/src/excelant/testcases/org/apache/poi/ss/excelant/util/TestExcelAntWorkbookUtil.java

Modified: poi/trunk/src/excelant/testcases/org/apache/poi/ss/excelant/util/TestExcelAntWorkbookUtil.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/excelant/testcases/org/apache/poi/ss/excelant/util/TestExcelAntWorkbookUtil.java?rev=1538281&r1=1538280&r2=1538281&view=diff
==============================================================================
--- poi/trunk/src/excelant/testcases/org/apache/poi/ss/excelant/util/TestExcelAntWorkbookUtil.java
(original)
+++ poi/trunk/src/excelant/testcases/org/apache/poi/ss/excelant/util/TestExcelAntWorkbookUtil.java
Sat Nov  2 20:58:22 2013
@@ -18,15 +18,16 @@ package org.apache.poi.ss.excelant.util;
 
 import java.io.File;
 import java.io.FileInputStream;
-import java.io.FileNotFoundException;
 import java.io.IOException;
 import java.util.ArrayList;
+import java.util.Date;
 
 import junit.framework.TestCase;
 
 import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
 import org.apache.poi.ss.examples.formula.CalculateMortgageFunction;
 import org.apache.poi.ss.formula.udf.UDFFinder;
+import org.apache.poi.ss.usermodel.DateUtil;
 import org.apache.poi.ss.usermodel.FormulaEvaluator;
 import org.apache.poi.ss.usermodel.Workbook;
 import org.apache.poi.ss.usermodel.WorkbookFactory;
@@ -39,6 +40,7 @@ public class TestExcelAntWorkbookUtil ex
 	private ExcelAntWorkbookUtilTestHelper fixture ;
 		
 	
+	@Override
 	public void tearDown() {
 		fixture = null ;
 	}
@@ -48,9 +50,18 @@ public class TestExcelAntWorkbookUtil ex
 				                                  mortgageCalculatorFileName ) ;
 		
 		assertNotNull( fixture ) ;
-		
 	}
 
+	public void testLoadNotExistingFile() {
+		try {
+			assertNotNull(new ExcelAntWorkbookUtilTestHelper( 
+				                                  "notexistingFile" ));
+			fail("Should catch exception here");
+		} catch (BuildException e) {
+			assertTrue(e.getMessage().contains("notexistingFile"));			
+		}
+	}
+	
 	public void testWorkbookConstructor() throws InvalidFormatException, IOException {
         File workbookFile = new File(mortgageCalculatorFileName);
         FileInputStream fis = new FileInputStream(workbookFile);
@@ -112,6 +123,16 @@ public class TestExcelAntWorkbookUtil ex
 		
  	}
 
+	public void testGetEvaluatorXLSX() {
+		fixture = new ExcelAntWorkbookUtilTestHelper( 
+                "test-data/spreadsheet/sample.xlsx") ;
+		
+		FormulaEvaluator evaluator = fixture.getEvaluator( 
+				"test-data/spreadsheet/sample.xlsx" ) ;
+		
+		assertNotNull( evaluator ) ;
+ 	}
+
 	public void testEvaluateCell() {
 		String cell = "'MortgageCalculator'!B4" ;
 		double expectedValue = 790.79 ;
@@ -155,4 +176,43 @@ public class TestExcelAntWorkbookUtil ex
 		assertEquals( cellValue, value ) ;
 		
 	}
+	
+	public void testSetDate() {
+		String cell = "'MortgageCalculator'!C14" ;
+		Date cellValue = new Date();
+		
+		fixture = new ExcelAntWorkbookUtilTestHelper( 
+                mortgageCalculatorFileName ) ;
+		
+		fixture.setDateValue( cell, cellValue ) ;
+		
+		double value = fixture.getCellAsDouble( cell ) ;
+		
+		assertNotNull( value ) ;
+		
+		assertEquals( DateUtil.getExcelDate(cellValue, false), value ) ;
+		
+	}
+
+	public void testGetNonexistingString() {
+		String cell = "'MortgageCalculator'!C33" ;
+		
+		fixture = new ExcelAntWorkbookUtilTestHelper( 
+                mortgageCalculatorFileName ) ;
+		
+		String value = fixture.getCellAsString( cell ) ;
+		
+		assertEquals( "", value ) ;
+	}
+
+	public void testGetNonexistingDouble() {
+		String cell = "'MortgageCalculator'!C33" ;
+		
+		fixture = new ExcelAntWorkbookUtilTestHelper( 
+                mortgageCalculatorFileName ) ;
+		
+		double value = fixture.getCellAsDouble( cell ) ;
+		
+		assertEquals( 0.0, value ) ;
+	}
 }



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message