Java XSSFCell.getNumericCellValue方法代碼示例

本文整理匯總了Java中org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue方法的典型用法代碼示例。如果您正苦於以下問題：Java XSSFCell.getNumericCellValue方法的具體用法？Java XSSFCell.getNumericCellValue怎麽用？Java XSSFCell.getNumericCellValue使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類org.apache.poi.xssf.usermodel.XSSFCell的用法示例。

在下文中一共展示了XSSFCell.getNumericCellValue方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: get

import org.apache.poi.xssf.usermodel.XSSFCell; //導入方法依賴的package包/類
public Object get(XSSFCell cell) {
    if (cell != null) {
        int cellType = cell.getCellType();
        switch (cellType) {
            case Cell.CELL_TYPE_NUMERIC:
                return cell.getNumericCellValue();
            case Cell.CELL_TYPE_BOOLEAN:
                return cell.getBooleanCellValue();
            default:
                try {
                    return cell.getStringCellValue();
                } catch (IllegalStateException mismatch) {
                    return null;
                }
        }
    } else {
        return null;
    }

}

開發者ID:theysay，項目名稱:preceive-batch，代碼行數:21，代碼來源:XLSXSourceProvider.java

示例2: getValue

import org.apache.poi.xssf.usermodel.XSSFCell; //導入方法依賴的package包/類
public static Object getValue(XSSFSheet sheet, int row, int col) {
    try {

        XSSFRow xrow = sheet.getRow(row);
        XSSFCell cell = xrow.getCell(col);

        switch (cell.getCellType()) {
            case Cell.CELL_TYPE_NUMERIC:
                return cell.getNumericCellValue();
            case Cell.CELL_TYPE_STRING:
                return (new DateComponentFormatter(
                        ComponentManager.getInstance().getComponentFormatDefaults().getSelectedDateFormat()))
                        .stringToValue(cell.getStringCellValue());
        }

    } catch (ParseException e) {
        e.printStackTrace();
    }

    return null;
}

開發者ID:pghazal，項目名稱:NoMoreLine，代碼行數:22，代碼來源:ExcelUtils.java

示例3: fromXSSFRowtoCSV

import org.apache.poi.xssf.usermodel.XSSFCell; //導入方法依賴的package包/類
private String fromXSSFRowtoCSV(XSSFRow row){
    StringBuffer csvRow = new StringBuffer();
    int l = row.getLastCellNum();
    for (int i=0;i<l;i++){
        XSSFCell cell = row.getCell((short)i);
        String cellValue = "";
        if (cell == null || cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) {
            cellValue = "";
        } else if (cell.getCellType()== HSSFCell.CELL_TYPE_STRING){
            cellValue = "\"" + cell.getStringCellValue() + "\"";
        } else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC){
            double value = cell.getNumericCellValue();
            cellValue = getNumberFormat().format(value);
            cellValue = "\"" + cellValue + "\"";
        }

        csvRow.append(cellValue);

        if (i<l){
            csvRow.append(getCsvDelimiter().toCharArray()[0]);
        }
    }
    return csvRow.toString();
}

開發者ID:sakaiproject，項目名稱:sakai，代碼行數:25，代碼來源:SpreadsheetUploadBean.java

示例4: validate

import org.apache.poi.xssf.usermodel.XSSFCell; //導入方法依賴的package包/類
@Override
public ValidationResult validate(XSSFCell cell) {
	int cellType = cell.getCellType();
	if (cellType == Cell.CELL_TYPE_BLANK) {
		return null;
	}

	double cellValue;
	if (cellType == Cell.CELL_TYPE_NUMERIC) {
		cellValue = cell.getNumericCellValue();
	} else if (cellType == Cell.CELL_TYPE_STRING) {
		 String stringValue = cell.getStringCellValue();
		 try{
			 cellValue = Double.parseDouble(stringValue);
			 //Warning 
		 }catch(NumberFormatException e){
			 //Error
			 return new ValidationResultImpl(cell.getSheet().getSheetName(), cell.getReference(),  false, "Value type is not as expected!");
		 }
	} else {
		return new ValidationResultImpl(cell.getSheet().getSheetName(), cell.getReference(), false, "Value type is not as expected!"); //Error
	}
	
	if (operator.check(cellValue)) {
		//True
		return null;
	} else {
		//Error
		return new ValidationResultImpl(cell.getSheet().getSheetName(), cell.getReference(), false, "Error!");
	}
}

開發者ID:ykaragol，項目名稱:poi-data-validation，代碼行數:32，代碼來源:DecimalValidator.java

示例5: getSingleValue

import org.apache.poi.xssf.usermodel.XSSFCell; //導入方法依賴的package包/類
private Double getSingleValue(XSSFSheet sheet, String formula) {
	try {
		return Double.parseDouble(formula);
	} catch (NumberFormatException e) {
		CellReference cellReference = new CellReference(formula);
		if (cellReference.getSheetName() != null) {
			sheet = sheet.getWorkbook().getSheet(cellReference.getSheetName());
		}
		XSSFRow row = sheet.getRow(cellReference.getRow());
		XSSFCell cell = row.getCell(cellReference.getCol());
		return cell.getNumericCellValue();
	}
}

開發者ID:ykaragol，項目名稱:poi-data-validation，代碼行數:14，代碼來源:DataValidator.java