return null; case HSSFCell.CELL_TYPE_FORMULA: return new Formula(cell.getCellFormula()); default: return StringUtils.trimToNull(cell.getStringCellValue());
poiCell.setCellValue(((Number) value).doubleValue()); } else if (value instanceof Formula) { poiCell.setCellFormula(((Formula) value).getExpr()); } else { poiCell.setCellValue(ConvertUtils.convert(value));
PropertyMapping mapping = new PropertyMapping(); mapping.add("balanceExpected", BigDecimal.ZERO); mapping.add("balance", new Formula("D" + firstDataRowNumber)); sheet.addRow(mapping.getMapping(), 0); mapping.add("creditsExpected", NumberHelper.isZeroOrNull(creditsExpected[i]) == true ? "" : creditsExpected[i]); mapping.add("debitsExpected", NumberHelper.isZeroOrNull(debitsExpected[i]) == true ? "" : debitsExpected[i]); mapping.add("balanceExpected", new Formula("D" + rowNumber + "+SUM(B" + rowNumber + ":C" + rowNumber + ")")); mapping.add("credits", NumberHelper.isZeroOrNull(credits[i]) == true ? "" : credits[i]); mapping.add("debits", NumberHelper.isZeroOrNull(debits[i]) == true ? "" : debits[i]); mapping.add("balance", new Formula("G" + rowNumber + "+SUM(E" + rowNumber + ":F" + rowNumber + ")")); sheet.addRow(mapping.getMapping(), 0); current.add(Calendar.DAY_OF_YEAR, 1); mapping.add("creditsExpected", new Formula("SUM(B" + firstDataRowNumber + ":B" + sheet.getRowCounter() + ")")); mapping.add("debitsExpected", new Formula("SUM(C" + firstDataRowNumber + ":C" + sheet.getRowCounter() + ")")); mapping.add("balanceExpected", new Formula("D" + firstDataRowNumber + "+SUM(B" + firstDataRowNumber + ":C" + sheet.getRowCounter() + ")")); mapping.add("credits", new Formula("SUM(E" + firstDataRowNumber + ":E" + sheet.getRowCounter() + ")")); mapping.add("debits", new Formula("SUM(F" + firstDataRowNumber + ":F" + sheet.getRowCounter() + ")")); mapping.add("balance", new Formula("G" + firstDataRowNumber + "+SUM(E" + firstDataRowNumber + ":F" + sheet.getRowCounter() + ")")); sheet.addRow(mapping.getMapping(), 0);