intersystems-ru/apache-poi

Apache poi integration with InterSyterms Data Platform

apache-poi

Apache poi integration with InterSyterms Data Platform

For instructions refer to this repository.

apache-poi's Issues

Unite

                switch (cell.getCellTypeEnum()) {
                    case FORMULA:
                        switch (cell.getCachedFormulaResultTypeEnum()) {
                            case NUMERIC:
                                if (HSSFDateUtil.isCellDateFormatted(cell)) {
                                    value = new java.sql.Date(cell.getDateCellValue().getTime());
                                } else {
                                    value = cell.getNumericCellValue();
                                }
                                break;
                            case STRING:
                                value = cell.getRichStringCellValue();
                                break;
                        }
                    case NUMERIC:
                        if (HSSFDateUtil.isCellDateFormatted(cell)) {
                            value = new java.sql.Date(cell.getDateCellValue().getTime());
                        } else {
                            value = cell.getNumericCellValue();
                        }
                        break;
                    case STRING:
                        value = cell.getRichStringCellValue().getString();
                        break;
                    case _NONE:
                    case BLANK:
                    case ERROR:
                        // not a null
                        value = "";
                        break;
                    case BOOLEAN:
                        value = cell.getBooleanCellValue();
                }