List of usage examples for org.apache.poi.hssf.usermodel HSSFCell getBooleanCellValue
@Override public boolean getBooleanCellValue()
From source file:no.trank.openpipe.parse.ms.ExcelParser.java
License:Apache License
private String getCellText(final HSSFCell cell) { String ret = null;//from w w w . j a v a2 s . c om // skip formula/error cells switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_NUMERIC: ret = cell.getNumericCellValue() + ""; break; case HSSFCell.CELL_TYPE_STRING: ret = cell.getRichStringCellValue() + ""; break; case HSSFCell.CELL_TYPE_BOOLEAN: ret = cell.getBooleanCellValue() ? "true" : "false"; } if (ret != null) { ret = ret.trim(); } return ret != null && ret.length() > 0 ? ret : null; }
From source file:org.akaza.openclinica.control.admin.SpreadSheetTableRepeating.java
License:LGPL
public String getValue(HSSFCell cell) { String val = null; int cellType = 0; if (cell == null) { cellType = HSSFCell.CELL_TYPE_BLANK; } else {/* w ww. jav a 2 s . c o m*/ cellType = cell.getCellType(); } switch (cellType) { case HSSFCell.CELL_TYPE_BLANK: val = ""; break; case HSSFCell.CELL_TYPE_NUMERIC: // YW << Modify code so that floating number alone can be used for // CRF version. Before it must use, e.g. v1.1 // Meanwhile modification has been done for read PHI cell and // Required cell val = cell.getNumericCellValue() + ""; // >> YW // buf.append("<td><font class=\"bodytext\">" + // cell.getNumericCellValue() // + "</font></td>"); // added to check for whole numbers, tbh 6/5/07 double dphi = cell.getNumericCellValue(); if ((dphi - (int) dphi) * 1000 == 0) { val = (int) dphi + ""; } // logger.debug("found a numeric cell after transfer: "+val); break; case HSSFCell.CELL_TYPE_STRING: val = cell.getStringCellValue(); if (val.matches("'")) { // logger.debug("Found single quote! "+val); val.replaceAll("'", "''"); } // buf.append("<td><font class=\"bodytext\">" + // cell.getStringCellValue() // + "</font></td>"); break; case HSSFCell.CELL_TYPE_BOOLEAN: boolean val2 = cell.getBooleanCellValue(); if (val2) { val = "true"; } else { val = "false"; } default: val = ""; // buf.append("<td></td>"); } return val.trim(); }
From source file:org.apache.cocoon.generation.HSSFGenerator.java
License:Apache License
/** * Returns the cell value./*from w w w. j a v a 2s . c o m*/ * @param cell POI cell * @return the cell value */ private String getValue(HSSFCell cell) { switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_BLANK: return ""; case HSSFCell.CELL_TYPE_BOOLEAN: return BooleanUtils.toStringTrueFalse(cell.getBooleanCellValue()); case HSSFCell.CELL_TYPE_NUMERIC: return Double.toString(cell.getNumericCellValue()); case HSSFCell.CELL_TYPE_ERROR: return "#ERR" + cell.getErrorCellValue(); case HSSFCell.CELL_TYPE_FORMULA: case HSSFCell.CELL_TYPE_STRING: default: return cell.getStringCellValue(); } }
From source file:org.apdplat.platform.generator.ModelGenerator.java
License:Open Source License
/** * ???EXCEL/*w ww.ja v a 2 s . co m*/ * ?EXCELJAVA * @param inputStream ??EXCEL * @return JAVA */ private static List<ModelInfo> readModelInfos(InputStream inputStream) { List<ModelInfo> models = new ArrayList<>(); try { HSSFWorkbook workbook = new HSSFWorkbook(inputStream); for (int i = 0; i < workbook.getNumberOfSheets(); i++) { HSSFSheet sheet = workbook.getSheetAt(i); try { HSSFRow row = sheet.getRow(2); if (row == null) { LOG.info("???" + sheet.getSheetName()); continue; } HSSFCell cell = row.getCell(1); //?? String modelPackage = cell.getStringCellValue(); row = sheet.getRow(3); cell = row.getCell(1); //?? String modelEnglish = cell.getStringCellValue(); row = sheet.getRow(4); cell = row.getCell(1); //?? String modelChinese = cell.getStringCellValue(); ModelInfo modelInfo = new ModelInfo(); modelInfo.setModelPackage(modelPackage); modelInfo.setModelEnglish(modelEnglish); modelInfo.setModelChinese(modelChinese); int rows = sheet.getPhysicalNumberOfRows(); //8?? for (int rowNumber = 7; rowNumber < rows; rowNumber++) { HSSFRow oneRow = sheet.getRow(rowNumber); if (oneRow == null) { continue; } Attr attr = new Attr(); //?? HSSFCell oneCell = oneRow.getCell(0); if (oneCell != null) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { attr.setDes(cellValue); } else { continue; } } //?? oneCell = oneRow.getCell(1); if (oneCell != null) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { attr.setName(cellValue); } else { continue; } } // oneCell = oneRow.getCell(2); if (oneCell != null) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { attr.setType(AttrType.validType(cellValue)); } else { attr.setType(AttrType.validType("String")); } } //?string oneCell = oneRow.getCell(3); if (oneCell != null) { if (oneCell.getCellType() == HSSFCell.CELL_TYPE_STRING) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { try { int length = Integer.parseInt(cellValue); attr.setLength(length); } catch (Exception e) { LOG.error("?" + cellValue); } } } if (oneCell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) { double length = oneCell.getNumericCellValue(); attr.setLength((int) length); } } //?? oneCell = oneRow.getCell(4); if (oneCell != null) { boolean cellValue = oneCell.getBooleanCellValue(); attr.setSearchable(cellValue); } //?? oneCell = oneRow.getCell(5); if (oneCell != null) { boolean cellValue = oneCell.getBooleanCellValue(); attr.setRenderIgnore(cellValue); } //?? oneCell = oneRow.getCell(6); if (oneCell != null) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { attr.setDic(DicType.validType(cellValue)); } } //??? oneCell = oneRow.getCell(7); if (oneCell != null) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { attr.setDicName(cellValue); } } // oneCell = oneRow.getCell(8); if (oneCell != null) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { attr.setMap(MapType.validType(cellValue)); } } // oneCell = oneRow.getCell(9); if (oneCell != null) { String cellValue = oneCell.getStringCellValue(); if (cellValue != null && !"".equals(cellValue.trim()) && !"null".equals(cellValue.trim().toLowerCase())) { attr.setAttrRef(cellValue); } } if ("Date".equals(attr.getType()) || "Time".equals(attr.getType())) { modelInfo.setHasDateTime(true); } if ("DicItem".equals(attr.getType())) { modelInfo.setHasDicItem(true); //DicItemdicSimpleDic if (!"SimpleDic".equals(attr.getDic()) && !"TreeDic".equals(attr.getDic())) { attr.setDic("SimpleDic"); } if (attr.getDicName() == null || "".equals(attr.getDicName())) { attr.setDicName(attr.getName()); } } modelInfo.addAttr(attr); } models.add(modelInfo); } catch (Exception e) { LOG.error("?:" + sheet.getSheetName() + " ", e); } } } catch (IOException e) { LOG.error("?MODEL", e); } return models; }
From source file:org.beanfuse.transfer.importer.reader.ExcelItemReader.java
License:Open Source License
/** * @see ?cell??/* www . ja va 2s . co m*/ * @param cell * @param objClass * @return */ private String getCelValue(HSSFCell cell) { if ((cell == null) || (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK)) return ""; if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) { return cell.getRichStringCellValue().getString(); } else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) { return numberFormat.format(cell.getNumericCellValue()); } else if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN) { if (cell.getBooleanCellValue()) return "true"; else return "false"; } else { return ""; } }
From source file:org.beangle.commons.transfer.excel.ExcelItemReader.java
License:Open Source License
/** * <p>/*from ww w. ja va2 s . c o m*/ * getCellValue. * </p> * * @see ?cell?? * @param cell a {@link org.apache.poi.hssf.usermodel.HSSFCell} object. * @return a {@link java.lang.Object} object. */ public static Object getCellValue(HSSFCell cell) { if ((cell == null)) return null; switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_BLANK: return null; case HSSFCell.CELL_TYPE_STRING: return Strings.trim(cell.getRichStringCellValue().getString()); case HSSFCell.CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { return cell.getDateCellValue(); } else { return numberFormat.format(cell.getNumericCellValue()); } case HSSFCell.CELL_TYPE_BOOLEAN: return (cell.getBooleanCellValue()) ? Boolean.TRUE : Boolean.FALSE; default: // cannot handle HSSFCell.CELL_TYPE_ERROR,HSSFCell.CELL_TYPE_FORMULA return null; } }
From source file:org.beangle.model.transfer.excel.ExcelItemReader.java
License:Open Source License
/** * @see ?cell??// w ww.ja v a2 s. co m * @param cell * @param objClass * @return */ public static Object getCellValue(HSSFCell cell) { if ((cell == null)) return null; switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_BLANK: return null; case HSSFCell.CELL_TYPE_STRING: return StringUtils.trim(cell.getRichStringCellValue().getString()); case HSSFCell.CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { return cell.getDateCellValue(); } else { return numberFormat.format(cell.getNumericCellValue()); } case HSSFCell.CELL_TYPE_BOOLEAN: return (cell.getBooleanCellValue()) ? Boolean.TRUE : Boolean.FALSE; default: // cannot handle HSSFCell.CELL_TYPE_ERROR,HSSFCell.CELL_TYPE_FORMULA return null; } }
From source file:org.databene.platform.xls.XLSEntityExporterTest.java
License:Open Source License
private static void checkCells(HSSFRow row, Object... values) { if (ArrayUtil.isEmpty(values)) assertNull(row);/*from w w w.j av a 2s . com*/ for (int i = 0; i < values.length; i++) { HSSFCell cell = row.getCell(i); Object expectedContent = values[i]; if (expectedContent == null) assertNull(cell); else if (expectedContent instanceof String) { assertEquals(HSSFCell.CELL_TYPE_STRING, cell.getCellType()); assertEquals(expectedContent, cell.getStringCellValue()); } else if (expectedContent instanceof Number) { assertEquals(HSSFCell.CELL_TYPE_NUMERIC, cell.getCellType()); assertEquals(((Number) expectedContent).doubleValue(), cell.getNumericCellValue()); } else if (expectedContent instanceof Boolean) { assertEquals(HSSFCell.CELL_TYPE_BOOLEAN, cell.getCellType()); assertEquals(expectedContent, cell.getBooleanCellValue()); } else if (expectedContent instanceof Date) { assertEquals(HSSFCell.CELL_TYPE_NUMERIC, cell.getCellType()); assertEquals(((Date) expectedContent).getTime() / 1000, cell.getDateCellValue().getTime() / 1000); // cut off milliseconds } else throw new RuntimeException("Type not supported: " + expectedContent.getClass()); } }
From source file:org.encuestame.business.search.IndexerFile.java
License:Apache License
/** * Extract spreadsheets content.// w ww . j a v a 2s . c o m * @param workBook * @return * @throws Exception */ public static String extractContentSpreadsheetsDocument(final HSSFWorkbook workBook) throws Exception { StringBuilder contents = new StringBuilder(); for (int i = 0; i < workBook.getNumberOfSheets(); i++) { HSSFSheet sheet = workBook.getSheetAt(i); Iterator<Row> rows = sheet.rowIterator(); while (rows.hasNext()) { HSSFRow row = (HSSFRow) rows.next(); // Display the row number log.debug(row.getRowNum()); Iterator<Cell> cells = row.cellIterator(); while (cells.hasNext()) { HSSFCell cell = (HSSFCell) cells.next(); // Display the cell number of the current Row switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_NUMERIC: { log.debug(String.valueOf(cell.getNumericCellValue())); contents.append(String.valueOf(cell.getNumericCellValue())).append(" "); break; } case HSSFCell.CELL_TYPE_STRING: { HSSFRichTextString richTextString = cell.getRichStringCellValue(); log.debug(richTextString.toString()); contents.append(richTextString.toString()).append(" "); break; } case HSSFCell.CELL_TYPE_BOOLEAN: { contents.append(String.valueOf(cell.getBooleanCellValue())).append(" "); break; } } } } } return contents.toString(); }
From source file:org.encuestame.business.search.SearchUtils.java
License:Apache License
/** * Create Spreadsheets Document.// ww w . j av a 2 s . co m * @param file Spreadsheet {@link File}. * @param Long attachmentId. * @return {@link Document} * @throws FileNotFoundException */ public static Document createSpreadsheetsDocument(final File file) throws Exception { InputStream is = new FileInputStream(file); StringBuilder contents = new StringBuilder(); POIFSFileSystem fileSystem = new POIFSFileSystem(is); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); for (int i = 0; i < workBook.getNumberOfSheets(); i++) { HSSFSheet sheet = workBook.getSheetAt(i); Iterator<Row> rows = sheet.rowIterator(); while (rows.hasNext()) { HSSFRow row = (HSSFRow) rows.next(); // Display the row number log.debug(row.getRowNum()); Iterator<Cell> cells = row.cellIterator(); while (cells.hasNext()) { HSSFCell cell = (HSSFCell) cells.next(); // Display the cell number of the current Row switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_NUMERIC: { log.debug(String.valueOf(cell.getNumericCellValue())); contents.append(String.valueOf(cell.getNumericCellValue())).append(" "); break; } case HSSFCell.CELL_TYPE_STRING: { HSSFRichTextString richTextString = cell.getRichStringCellValue(); log.debug(richTextString.toString()); contents.append(richTextString.toString()).append(" "); break; } case HSSFCell.CELL_TYPE_BOOLEAN: { contents.append(String.valueOf(cell.getBooleanCellValue())).append(" "); break; } } } } } Document doc = SearchUtils.addFields(file, contents.toString()); return doc; }