@Test
public void serialize() throws SerDeException {

	// initialize Serde
	ExcelSpreadSheetCellDAOSerde testSerde = new ExcelSpreadSheetCellDAOSerde();
	Configuration hadoopConf = new Configuration();
	Properties tblProperties = new Properties();
	tblProperties.setProperty("hadoopoffice.write.locale.bcp47", "de");
	testSerde.initialize(hadoopConf, tblProperties);
	// get object inspector
	ObjectInspector oi = testSerde.getObjectInspector();
	String[] testHiveStructure = new String[5];
	testHiveStructure[0] = "test1";
	testHiveStructure[1] = "no comment";
	testHiveStructure[2] = "A1*A2";
	testHiveStructure[3] = "A3";
	testHiveStructure[4] = "Sheet1";
	SpreadSheetCellDAO resultDAO = (SpreadSheetCellDAO) testSerde.serialize(testHiveStructure, oi);
	assertEquals(testHiveStructure[0],resultDAO.getFormattedValue(),"formatted value correct");
	assertEquals(testHiveStructure[1],resultDAO.getComment(),"comment correct");
	assertEquals(testHiveStructure[2],resultDAO.getFormula(), "formula correct");
	assertEquals(testHiveStructure[3],resultDAO.getAddress(), "address correct");
	assertEquals(testHiveStructure[4],resultDAO.getSheetName(),"sheetname correct");
}