當前位置: 首頁>>代碼示例>>Java>>正文

Java XSSFCell.CELL_TYPE_BLANK屬性代碼示例

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


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

示例1: getCellValue

/**
 * Gets the cell value.
 *
 * @param cell the cell
 * @return the cell value
 */
private String getCellValue( XSSFCell cell )
{
	if (cell != null)
	{
		switch (cell.getCellType())
		{
			case XSSFCell.CELL_TYPE_BLANK:
				return null;
			case XSSFCell.CELL_TYPE_BOOLEAN:
				return String.valueOf( cell.getBooleanCellValue() );
			case XSSFCell.CELL_TYPE_NUMERIC:
				return String.valueOf( ( int ) cell.getNumericCellValue() );
			case XSSFCell.CELL_TYPE_STRING:
				return cell.getRichStringCellValue().toString();

		}
	}
	return null;
}
開發者ID:xframium，項目名稱:xframium-java，代碼行數:25，代碼來源:ExcelDataProvider.java

示例2: 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

示例3: getCellValue

/**
 * Gets the cell value.
 *
 * @param cell the cell
 * @return the cell value
 */
private String getCellValue( XSSFCell cell )
{
	if (cell != null)
	{
		switch (cell.getCellType())
		{
			case XSSFCell.CELL_TYPE_BLANK:
				return null;
			case XSSFCell.CELL_TYPE_BOOLEAN:
				return String.valueOf( cell.getBooleanCellValue() );
			case XSSFCell.CELL_TYPE_NUMERIC:
				return String.valueOf( cell.getNumericCellValue() );
			case XSSFCell.CELL_TYPE_STRING:
				return cell.getRichStringCellValue().toString();
		}
	}
	return null;
}
開發者ID:xframium，項目名稱:xframium-java，代碼行數:24，代碼來源:ExcelCloudProvider.java

示例4: getCellValue

/**
 * Gets the cell value.
 *
 * @param cell the cell
 * @return the cell value
 */
private String getCellValue( XSSFCell cell )
{
	if (cell != null)
	{
		switch (cell.getCellType())
		{
			case XSSFCell.CELL_TYPE_BLANK:
				return null;
			case XSSFCell.CELL_TYPE_BOOLEAN:
				return String.valueOf( cell.getBooleanCellValue() );
			case XSSFCell.CELL_TYPE_NUMERIC:
			{
			    String useValue = String.valueOf( cell.getNumericCellValue() );
			    if ( useValue.endsWith( ".0" ) )
			        return useValue.split( "\\." )[0];
			    else
			        return useValue;
			}
			case XSSFCell.CELL_TYPE_STRING:
				return cell.getRichStringCellValue().toString();
		}
	}
	return null;
}
開發者ID:xframium，項目名稱:xframium-java，代碼行數:30，代碼來源:ExcelPageDataProvider.java

示例5: getCellValue

private String getCellValue( XSSFCell cell )
{
    if (cell != null )
    {
        switch (cell.getCellType())
        {
            case XSSFCell.CELL_TYPE_BLANK:
                return null;
            case XSSFCell.CELL_TYPE_BOOLEAN:
                return String.valueOf( cell.getBooleanCellValue() );
            case XSSFCell.CELL_TYPE_NUMERIC:
                return String.valueOf( cell.getNumericCellValue() );
            case XSSFCell.CELL_TYPE_STRING:
                return cell.getRichStringCellValue().toString();
        }
    }
    return null;
}
開發者ID:xframium，項目名稱:xframium-java，代碼行數:18，代碼來源:ExcelKeyWordProvider.java

示例6: 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

示例7: 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

示例8: 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

示例9: shiftRange

private void shiftRange(int numRowsDown, int rowStart, int rowEnd, int colStart, int colEnd) throws Exception {
        // loop through from bottom row up to either SHIFT the whole row, or copy necessary columns, insert  new row below, insert the data from the cell and then delete all style and format from the original cell
        for(int j=rowEnd;j>rowStart;j--) {
            XSSFRow row = worksheet.getRow(j);
            XSSFRow newRow = worksheet.getRow(j+numRowsDown);
            if(row == null && newRow == null) 
                continue;
            else if (row == null) {
                worksheet.removeRow(newRow);
                continue;
            }
            if(newRow == null) {
                newRow = worksheet.createRow(j+numRowsDown);
            }
//            newRow = worksheet.getRow(j+numRowsDown);
            //if(row ==null) continue;
            for(int k=colStart;k<=colEnd;k++) {
                XSSFCell cell = row.getCell(k);
                if(cell != null) {
                    XSSFCell newCell = newRow.getCell(k)==null ? newRow.createCell(k) : newRow.getCell(k);
                    if(cell==null) continue;
                    if(cell.getCellType() == XSSFCell.CELL_TYPE_FORMULA) {
                        String calc = cell.getCellFormula();
                        newCell.setCellStyle(cell.getCellStyle());
                        cell.setCellType(XSSFCell.CELL_TYPE_BLANK);
                        this.setCellFormula(newCell, calc);
                    } else if(cell.getCellType()==XSSFCell.CELL_TYPE_BLANK) {
                        newCell.setCellType(XSSFCell.CELL_TYPE_BLANK);
                    } else {
                        newCell.copyCellFrom(cell, new CellCopyPolicy());
                        newCell.setCellStyle(cell.getCellStyle());
                    }
                }
            }
        }
    }
開發者ID:linearblue，項目名稱:ExcelInjector，代碼行數:36，代碼來源:ExcelTableInjector.java

示例10: checkForContent

private int checkForContent(int rowStart, int rowEnd, int colStart, int colEnd) throws Exception {
    for(int j=rowEnd;j>rowStart;j--) {
        XSSFRow row = worksheet.getRow(j);
        if(row ==null) continue;
        for(int k=colStart;k<=colEnd;k++) {
            XSSFCell cell = row.getCell(k);
            if(cell==null) continue;
            if(cell.getCellType() == XSSFCell.CELL_TYPE_BLANK) continue;
            return j;
        }
    }
    return 0;
}
開發者ID:linearblue，項目名稱:ExcelInjector，代碼行數:13，代碼來源:ExcelTableInjector.java

示例11: readInt

/**
 * 讀取 Int 數值
 *
 * @return
 *
 */
public Integer readInt() {
    final XSSFCell cell = this.readCell();

    if (cell == null ||
        cell.getCellType() == XSSFCell.CELL_TYPE_BLANK) {
        return null;
    } else {
        return XSSFUtil.getIntCellVal(cell);
    }
}
開發者ID:hjj2017，項目名稱:xgame-code_server，代碼行數:16，代碼來源:XSSFRowReadStream.java

示例12: readLong

/**
 * 讀取 Long 數值
 *
 * @return
 *
 */
public Long readLong() {
    final XSSFCell cell = this.readCell();

    if (cell == null ||
        cell.getCellType() == XSSFCell.CELL_TYPE_BLANK) {
        return null;
    } else {
        return XSSFUtil.getLongCellVal(cell);
    }
}
開發者ID:hjj2017，項目名稱:xgame-code_server，代碼行數:16，代碼來源:XSSFRowReadStream.java

示例13: readShort

/**
 * 讀取 Short 數值
 *
 * @return
 *
 */
public Short readShort() {
    final XSSFCell cell = this.readCell();

    if (cell == null ||
        cell.getCellType() == XSSFCell.CELL_TYPE_BLANK) {
        return null;
    } else {
        return XSSFUtil.getShortCellVal(cell);
    }
}
開發者ID:hjj2017，項目名稱:xgame-code_server，代碼行數:16，代碼來源:XSSFRowReadStream.java

示例14: readStr

/**
 * 讀取 Str 數值
 *
 * @return
 *
 */
public String readStr() {
    final XSSFCell cell = this.readCell();

    if (cell == null ||
        cell.getCellType() == XSSFCell.CELL_TYPE_BLANK) {
        return null;
    } else {
        return XSSFUtil.getStrCellVal(cell);
    }
}
開發者ID:hjj2017，項目名稱:xgame-code_server，代碼行數:16，代碼來源:XSSFRowReadStream.java

示例15: readBool

/**
 * 讀取 Bool 數值
 *
 * @return
 *
 */
public Boolean readBool() {
    final XSSFCell cell = this.readCell();

    if (cell == null ||
        cell.getCellType() == XSSFCell.CELL_TYPE_BLANK) {
        return false;
    } else {
        return XSSFUtil.getBoolCellVal(cell);
    }
}
開發者ID:hjj2017，項目名稱:xgame-code_server，代碼行數:16，代碼來源:XSSFRowReadStream.java


注：本文中的org.apache.poi.xssf.usermodel.XSSFCell.CELL_TYPE_BLANK屬性示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。