source: class ExcelConverterSimpleSpreadSheetCellDAOTest {
  
  	    @Test
  	    public void getSpreadSheetCellDAOfromSimpleDataType() throws ParseException {
  
target: 		    	// configure converter
  	    		SimpleDateFormat dateFormat = (SimpleDateFormat)DateFormat.getDateInstance(DateFormat.SHORT, Locale.US);
  	    		DecimalFormat decimalFormat = (DecimalFormat) DecimalFormat.getInstance(Locale.GERMAN);
  	    		ExcelConverterSimpleSpreadSheetCellDAO converter = new ExcelConverterSimpleSpreadSheetCellDAO(dateFormat,decimalFormat);
  	    		// test some rows
  	    		Object[] rowA = new Object[13];
  	    		rowA[0] = new Boolean(true);
  	    		rowA[1] = new Byte((byte) 100);
  	    		rowA[2] = new Short((short) 1000);
  	    		rowA[3] = new Integer(32000);
  	    		rowA[4] = new Long(65536L);
  	    		rowA[5] = new Double(2.5);
  	    		rowA[6] = new Float(3.5f);
  	    		rowA[7] = new BigDecimal(1.5);
  	    		rowA[8] = dateFormat.parse("1/13/2018");
  	    		rowA[9] = new java.sql.Date(dateFormat.parse("1/13/2018").getTime());
  	    		rowA[10] = new Timestamp(dateFormat.parse("1/13/2018").getTime());
  	    		rowA[11] = "This is a test";
  	    		rowA[12] = null;
  	    		SpreadSheetCellDAO[] actual = converter.getSpreadSheetCellDAOfromSimpleDataType(rowA, "testsheet", 0);
  	    		assertEquals("",actual[0].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[0].getComment(),"Comment is empty");
  	    		assertEquals("true",actual[0].getFormula(),"Formula contains data type");
  	    		assertEquals("A1",actual[0].getAddress(),"Address is correct");
  	    		assertEquals("",actual[1].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[1].getComment(),"Comment is empty");
  	    		assertEquals("100",actual[1].getFormula(),"Formula contains data type");
  	    		assertEquals("B1",actual[1].getAddress(),"Address is correct");
  	    		assertEquals("",actual[2].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[2].getComment(),"Comment is empty");
  	    		assertEquals("1000",actual[2].getFormula(),"Formula contains data type");
  	    		assertEquals("C1",actual[2].getAddress(),"Address is correct");
  	    		assertEquals("",actual[3].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[3].getComment(),"Comment is empty");
  	    		assertEquals("32000",actual[3].getFormula(),"Formula contains data type");
  	    		assertEquals("D1",actual[3].getAddress(),"Address is correct");
  	    		assertEquals("",actual[4].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[4].getComment(),"Comment is empty");
  	    		assertEquals("65536",actual[4].getFormula(),"Formula contains data type");
  	    		assertEquals("E1",actual[4].getAddress(),"Address is correct");
  	    		assertEquals("",actual[5].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[5].getComment(),"Comment is empty");
  	    		assertEquals("2.5",actual[5].getFormula(),"Formula contains data type");
  	    		assertEquals("F1",actual[5].getAddress(),"Address is correct");
  	    		assertEquals("",actual[6].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[6].getComment(),"Comment is empty");
  	    		assertEquals("3.5",actual[6].getFormula(),"Formula contains data type");
  	    		assertEquals("G1",actual[6].getAddress(),"Address is correct");
  	    		assertEquals("",actual[7].getFormattedValue(),"Formatted Value is empty");
  	    		assertEquals("",actual[7].getComment(),"Comment is empty");
  	    		assertEquals("1.5",actual[7].getFormula(),"Formula contains data type");
  	    		assertEquals("H1",actual[7].getAddress(),"Address is correct");
  	    		assertEquals("1/13/18",actual[8].getFormattedValue(),"Formatted Value contains data type");
  	    		assertEquals("",actual[8].getComment(),"Comment is empty");
  	    		assertEquals("",actual[8].getFormula(),"Formula is empty");
  	    		assertEquals("I1",actual[8].getAddress(),"Address is correct");
  	    		assertEquals("1/13/18",actual[9].getFormattedValue(),"Formatted Value contains data type");
  	    		assertEquals("",actual[9].getComment(),"Comment is empty");
  	    		assertEquals("",actual[9].getFormula(),"Formula is empty");
  	    		assertEquals("J1",actual[9].getAddress(),"Address is correct");
  	    		assertEquals("2018-01-13 00:00:00.0",actual[10].getFormattedValue(),"Formatted Value contains data type");
  	    		assertEquals("",actual[10].getComment(),"Comment is empty");
  	    		assertEquals("",actual[10].getFormula(),"Formula is empty");
  	    		assertEquals("K1",actual[10].getAddress(),"Address is correct");
  	    		assertEquals("This is a test",actual[11].getFormattedValue(),"Formatted Value contains data");
  	    		assertEquals("",actual[11].getComment(),"Comment is empty");
  	    		assertEquals("",actual[11].getFormula(),"Formula is empty");
  	    		assertEquals("L1",actual[11].getAddress(),"Address is correct");
  	    		assertNull(actual[12],"Null values stay null");
  	    }
  
  }