String fiscalNumber = getValueFromColumnMayBeNull(row, 2);
String name = getValueFromColumnMayBeNull(row, 3);
Double roomValue = new Double(row.getCell((short) 4).getNumericCellValue());
String paidDate = getDateFromColumn(row, 5);
Double roomValuePaid = new Double(row.getCell((short) 6).getNumericCellValue());
ResidenceDebtEventBean residenceDebtEventBean =
new ResidenceDebtEventBean(userName, fiscalNumber, name, roomValue, room, paidDate, roomValuePaid);
residenceDebtEventBean.setMonth(bean.getResidenceMonth());
beans.add(residenceDebtEventBean);
i++;
}
return beans;