private Contact processRow(HSSFRow row, Map headerTable) { Contact contact = null; String name = retriveCellData(row, headerTable, "NOME"); List categories = retrieveCategories(row, headerTable); Companie companie = retrieveCompany(row, headerTable, categories); if (!name.equals("")) { contact = new Contact(); contact.setName(retriveCellData(row, headerTable, "NOME")); contact.setSex(retriveCellData(row, headerTable, "SEXO")); contact.setStreetAddress(retriveCellData(row, headerTable, "ENDEREÇO")); contact.setPostalCode(retriveCellData(row, headerTable, "CEP")); contact.setCity(retriveCellData(row, headerTable, "CIDADE")); contact.setState(retriveCellData(row, headerTable, "ESTADO")); contact.setCountry("BR"); contact.setPhone(processFoneNumber(row, headerTable, "TEL RESIDENCIAL")); contact.setCellular(processFoneNumber(row, headerTable, "CELULAR")); contact.setEmail(retriveCellData(row, headerTable, "E-MAIL 1")); contact.setEmail2(retriveCellData(row, headerTable, "E-MAIL 2")); contact.setUrl(retriveCellData(row, headerTable, "SITE")); contact.setDepartment(retriveCellData(row, headerTable, "ÁREA")); contact.setFunction(retriveCellData(row, headerTable, "CARGO")); contact.setPhoneWork(processFoneNumber(row, headerTable, "TEL COMERCIAL")); contact.setFax(processFoneNumber(row, headerTable, "FAX")); contact.setComments(retriveCellData(row, headerTable, "OBSERVAÇÃO")); contact.setIndication(retriveCellData(row, headerTable, "INDICACAO")); contact.setCompany(companie); // contact.setCategory(categoryId); contact.setCategories(categories); contact.setUsername(ETEAM_USER); } return contact; }