当前位置: 首页>>代码示例>>Java>>正文

Java XSSFCell.CELL_TYPE_ERROR属性代码示例

本文整理汇总了Java中org.apache.poi.xssf.usermodel.XSSFCell.CELL_TYPE_ERROR属性的典型用法代码示例。如果您正苦于以下问题：Java XSSFCell.CELL_TYPE_ERROR属性的具体用法？Java XSSFCell.CELL_TYPE_ERROR怎么用？Java XSSFCell.CELL_TYPE_ERROR使用的例子？那么, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类org.apache.poi.xssf.usermodel.XSSFCell的用法示例。


在下文中一共展示了XSSFCell.CELL_TYPE_ERROR属性的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: stringValueOf

protected String stringValueOf(CellValue value) {
    switch (value.getCellType()) {
        case XSSFCell.CELL_TYPE_STRING:
            return value.getStringValue();
        case XSSFCell.CELL_TYPE_NUMERIC:
            return String.valueOf(value.getNumberValue());
        case XSSFCell.CELL_TYPE_BLANK:
            return "";
        case XSSFCell.CELL_TYPE_BOOLEAN:
            return String.valueOf(value.getBooleanValue());
        case XSSFCell.CELL_TYPE_ERROR:
            return "error";
        default:
            return "unknown";
    }
}
开发者ID:aalexandrov，项目名称:arch-tools，代码行数:16，代码来源:ClusteringService.java

示例2: getCellTypeName

/**
 * 获取单元格类型名称
 *
 * @param cell
 * @return
 *
 */
public static String getCellTypeName(XSSFCell cell) {
    if (cell == null) {
        return "null";
    }

    switch (cell.getCellType()) {
    case XSSFCell.CELL_TYPE_BLANK: return "CELL_TYPE_BLANK";
    case XSSFCell.CELL_TYPE_BOOLEAN: return "CELL_TYPE_BOOLEAN";
    case XSSFCell.CELL_TYPE_ERROR: return "CELL_TYPE_ERROR";
    case XSSFCell.CELL_TYPE_FORMULA: return "CELL_TYPE_FORMULA";
    case XSSFCell.CELL_TYPE_NUMERIC: return "CELL_TYPE_NUMERIC";
    case XSSFCell.CELL_TYPE_STRING: return "CELL_TYPE_STRING";
    default: return "unknown";
    }
}
开发者ID:hjj2017，项目名称:xgame-code_server，代码行数:22，代码来源:XSSFUtil.java

示例3: cellValues2String

/**
 * Get the value of the excel-cell as String.
 * 
 * @param workbook
 *            workbook (excel) for evaluating cell formulas
 * @param cell
 *            cell (excel)
 * 
 * @return the value of the excel-cell as String
 */
static String cellValues2String(XSSFWorkbook workbook, XSSFCell cell) {
	if (cell == null) {
		return null;
	}
	switch (cell.getCellType()) {
	case XSSFCell.CELL_TYPE_NUMERIC:
		if (HSSFDateUtil.isCellDateFormatted(cell)) {
			return new SimpleDateFormat(JExUnitConfig.getStringProperty(JExUnitConfig.ConfigKey.DATE_PATTERN))
					.format(cell.getDateCellValue());
		} else {
			return String.valueOf(cell.getNumericCellValue());
		}
	case XSSFCell.CELL_TYPE_STRING:
		return cell.getStringCellValue();
	case XSSFCell.CELL_TYPE_FORMULA:
		return evaluateCellFormula(workbook, cell);
	case XSSFCell.CELL_TYPE_BLANK:
		return cell.getStringCellValue();
	case XSSFCell.CELL_TYPE_BOOLEAN:
		return String.valueOf(cell.getBooleanCellValue());
	case XSSFCell.CELL_TYPE_ERROR:
		return String.valueOf(cell.getErrorCellValue());
	}
	return null;
}
开发者ID:fhm84，项目名称:jexunit，代码行数:35，代码来源:ExcelLoader.java

示例4: copyCell

/**
 * @param oldCell
 * @param newCell
 * @param styleMap
 */
public static void copyCell(XSSFCell oldCell, XSSFCell newCell, Map<Integer, XSSFCellStyle> styleMap) {
    if (styleMap != null) {
        if (oldCell.getSheet().getWorkbook() == newCell.getSheet().getWorkbook()) {
            newCell.setCellStyle(oldCell.getCellStyle());
        } else {
            int stHashCode = oldCell.getCellStyle().hashCode();
            XSSFCellStyle newCellStyle = styleMap.get(stHashCode);
            if (newCellStyle == null) {
                newCellStyle = newCell.getSheet().getWorkbook().createCellStyle();
                newCellStyle.cloneStyleFrom(oldCell.getCellStyle());
                styleMap.put(stHashCode, newCellStyle);
            }
            newCell.setCellStyle(newCellStyle);
        }
    }
    switch (oldCell.getCellType()) {
        case XSSFCell.CELL_TYPE_STRING:
            newCell.setCellValue(oldCell.getStringCellValue());
            break;
        case XSSFCell.CELL_TYPE_NUMERIC:
            newCell.setCellValue(oldCell.getNumericCellValue());
            break;
        case XSSFCell.CELL_TYPE_BLANK:
            newCell.setCellType(XSSFCell.CELL_TYPE_BLANK);
            break;
        case XSSFCell.CELL_TYPE_BOOLEAN:
            newCell.setCellValue(oldCell.getBooleanCellValue());
            break;
        case XSSFCell.CELL_TYPE_ERROR:
            newCell.setCellErrorValue(oldCell.getErrorCellValue());
            break;
        case XSSFCell.CELL_TYPE_FORMULA:
            newCell.setCellFormula(oldCell.getCellFormula());
            break;
        default:
            break;
    }

}
开发者ID:likelet，项目名称:DAtools，代码行数:44，代码来源:Util.java

示例5: copyCell

/**
 * Copy a cell to another cell
 * 
 * @param oldCell cell to be copied
 * @param newCell cell to be created
 * @param styleMap style map
 */
public static void copyCell(XSSFCell oldCell, XSSFCell newCell, Map<Integer, CellStyle> styleMap) {
	if (styleMap != null) {			
		if (oldCell.getSheet().getWorkbook() == newCell.getSheet().getWorkbook()) {
			newCell.setCellStyle(oldCell.getCellStyle());
		} else {				
			int stHashCode = oldCell.getCellStyle().hashCode();
			CellStyle newCellStyle = styleMap.get(stHashCode);				
			if (newCellStyle == null) {					
				newCellStyle = newCell.getSheet().getWorkbook().createCellStyle();
				newCellStyle.cloneStyleFrom(oldCell.getCellStyle());					
				styleMap.put(stHashCode, newCellStyle);
			}
			newCell.setCellStyle(newCellStyle);
		}			
	}
	switch (oldCell.getCellType()) {
	case XSSFCell.CELL_TYPE_STRING:
		newCell.setCellValue(oldCell.getStringCellValue());
		break;
	case XSSFCell.CELL_TYPE_NUMERIC:
		newCell.setCellValue(oldCell.getNumericCellValue());
		break;
	case XSSFCell.CELL_TYPE_BLANK:
		newCell.setCellType(XSSFCell.CELL_TYPE_BLANK);
		break;
	case XSSFCell.CELL_TYPE_BOOLEAN:
		newCell.setCellValue(oldCell.getBooleanCellValue());
		break;
	case XSSFCell.CELL_TYPE_ERROR:
		newCell.setCellErrorValue(oldCell.getErrorCellValue());
		break;
	case XSSFCell.CELL_TYPE_FORMULA:
		newCell.setCellFormula(oldCell.getCellFormula());
		break;
	default:
		break;
	}

}
开发者ID:nextreports，项目名称:nextreports-engine，代码行数:46，代码来源:XlsxUtil.java

示例6: getExcelReader

public static List<Map<String, String>> getExcelReader() {
	
	String[] colName = { "monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "sunday" };
	
	List<Map<String, String>> list = new ArrayList<Map<String, String>>();
	
	try {
		
		FileInputStream fis = new FileInputStream("c:\\wdmFx\\db\\webtoonList1.xlsx");
		
		XSSFWorkbook workbook = new XSSFWorkbook(fis);
		
		// 시트 수 (첫번째에만 존재하므로 0을 준다)
		// 만약 각 시트를 읽기위해서는 FOR문을 한번더 돌려준다
		XSSFSheet sheet = workbook.getSheetAt(0);
		int rows = sheet.getPhysicalNumberOfRows();
		
		Map<String, String> map = null;

		for (int i = 0; i < rows; i++) {

			if (i != 0) {

				XSSFRow row = sheet.getRow(i); // 행을 읽는다

				String value = "";

				// 셀의 갯수를 실제 필드갯수로 지정.
				int cells = colName.length;

				map = new LinkedHashMap<String, String>();

				for (int j = 0; j < cells; j++) {

					XSSFCell cell = row.getCell(j); // 셀값을 읽는다

					if (cell != null) {
						switch (cell.getCellType()) {
						case XSSFCell.CELL_TYPE_FORMULA:
							if (!"".equals(cell.toString())) {
								value = cell.getCellFormula();
							}
							break;
						case XSSFCell.CELL_TYPE_NUMERIC:
							value = cell.getRawValue();
							break;
						case XSSFCell.CELL_TYPE_STRING:
							value = cell.getStringCellValue();
							break;
						case XSSFCell.CELL_TYPE_BLANK:
							value = "";
							break;
						case XSSFCell.CELL_TYPE_ERROR:
							value = cell.getErrorCellValue() + "";
							break;
						default:
							break;
						}

						map.put(colName[j], value);
					}

				} // end for

				if (map.get(colName[0]) != null)
					list.add(map);
				
			} // end for
			
		}
		
	} catch (IOException e) {
		e.printStackTrace();
	}

	return list;
}
开发者ID:kimyearho，项目名称:WebtoonDownloadManager，代码行数:77，代码来源:ExcelReader.java

示例7: getValue

/**
 * <p>
 * xlsx 엑셀의 셀값을 String 타입으로 변환하여 리턴한다.
 * </p>
 * @param cell
 *        <code>XSSFCell</code>
 * @return 결과 값
 */
public static String getValue(XSSFCell cell) {
	
	String result = "";
	
	if (null == cell || cell.equals(null))
		return "";
	
	if (cell.getCellType() == XSSFCell.CELL_TYPE_BOOLEAN) {
		log.debug("### XSSFCell.CELL_TYPE_BOOLEAN : "
				+ XSSFCell.CELL_TYPE_BOOLEAN);
		result = String.valueOf(cell.getBooleanCellValue());
		
	} else if (cell.getCellType() == XSSFCell.CELL_TYPE_ERROR) {
		log.debug("### XSSFCell.CELL_TYPE_ERROR : "
				+ XSSFCell.CELL_TYPE_ERROR);
		// byte errorValue =
		// cell.getErrorCellValue();
		
	} else if (cell.getCellType() == XSSFCell.CELL_TYPE_FORMULA) {
		log.debug("### XSSFCell.CELL_TYPE_FORMULA : "
				+ XSSFCell.CELL_TYPE_FORMULA);
		
		String stringValue = cell.getRichStringCellValue().getString();
		String longValue = doubleToString(cell.getNumericCellValue());
		
		result =
				EgovStringUtil.isNumeric(longValue) ? longValue : stringValue;
		
	} else if (cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC) {
		log.debug("### XSSFCell.CELL_TYPE_NUMERIC : "
				+ XSSFCell.CELL_TYPE_NUMERIC);
		
		result =
				HSSFDateUtil.isCellDateFormatted(cell)
				? EgovDateUtil.toString(cell.getDateCellValue(),
						"yyyy/MM/dd", null) : doubleToString(cell
								.getNumericCellValue());
				
	} else if (cell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
		log.debug("### XSSFCell.CELL_TYPE_STRING : "
				+ XSSFCell.CELL_TYPE_STRING);
		result = cell.getRichStringCellValue().getString();
		
	} else if (cell.getCellType() == XSSFCell.CELL_TYPE_BLANK) {
		log.debug("### XSSFCell.CELL_TYPE_BLANK : "
				+ XSSFCell.CELL_TYPE_BLANK);
	}
	
	return result;
}
开发者ID:eGovFrame，项目名称:egovframework.rte.root，代码行数:58，代码来源:EgovExcelUtil.java


注：本文中的org.apache.poi.xssf.usermodel.XSSFCell.CELL_TYPE_ERROR属性示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。