Java CellType类代码示例

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * 获取单元格的值
 * 
 * @param cell
 * @return
 */
public static Object getCellValue(Cell cell) {
	Object cellValue = null;
	CellType cellType = cell.getCellTypeEnum();// CellType.forInt(cell.getCellType());
	if (cellType == CellType.STRING) {
		cellValue = cell.getStringCellValue();
	} else if (cellType == CellType.NUMERIC) {
		if (DateUtil.isCellDateFormatted(cell)) {
			cellValue = cell.getDateCellValue();
		} else {
			cellValue = cell.getNumericCellValue();
		}
	} else if (cellType == CellType.BOOLEAN) {
		cellValue = cell.getBooleanCellValue();
	} else if (cellType == CellType.FORMULA) {
		cellValue = cell.getCellFormula();
	} else if (cellType == CellType.BLANK) {
		cellValue = "";
	}
	return cellValue;
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * Return the cell type.
 *
 * @return the cell type
 * Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.
 */
@Override
public CellType getCellTypeEnum() {
  if(contentsSupplier.getContent() == null || type == null) {
    return CellType.BLANK;
  } else if("n".equals(type)) {
    return CellType.NUMERIC;
  } else if("s".equals(type) || "inlineStr".equals(type)) {
    return CellType.STRING;
  } else if("str".equals(type)) {
    return CellType.FORMULA;
  } else if("b".equals(type)) {
    return CellType.BOOLEAN;
  } else if("e".equals(type)) {
    return CellType.ERROR;
  } else {
    throw new UnsupportedOperationException("Unsupported cell type '" + type + "'");
  }
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * readCellByType is used because CELL_TYPE_FORMULA can be CELL_TYPE_NUMERIC, CELL_TYPE_NUMERIC(date) or CELL_TYPE_STRING.
 *
 * @param cellcell
 *            read (line and column)
 * @param type
 *            CELL_TYPE_FORMULA can be CELL_TYPE_NUMERIC, CELL_TYPE_NUMERIC(date) or CELL_TYPE_STRING
 * @return a string with the data (evalued if CELL_TYPE_FORMULA)
 */
private String readCellByType(Cell cell, CellType type) {
    String txt = "";
    if (cell != null) {
        switch (type) {
            case NUMERIC:
                txt = dateOrNumberProcessing(cell);
                break;
            case STRING:
                txt = String.valueOf(cell.getRichStringCellValue());
                logger.debug("CELL_TYPE_STRING: {}", txt);
                break;
            case FORMULA:
                txt = readCellByType(cell, cell.getCachedFormulaResultTypeEnum());
                logger.debug("CELL_TYPE_FORMULA: {}", txt);
                break;
            case BLANK:
                logger.debug("CELL_TYPE_BLANK (we do nothing)");
                break;
            default:
                logger.error(Messages.getMessage(EXCEL_DATA_PROVIDER_WRONG_CELL_TYPE_ERROR_MESSAGE), type);
                break;
        }
    }
    return txt;
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
private static void create(Stream<?> stream, Row row) {
    AtomicInteger counter = new AtomicInteger();
    stream.forEach(value -> {
        if (value != null) {
            if (value instanceof String) {
                row.createCell(counter.getAndIncrement(), CellType.STRING).setCellValue((String) value);
            } else if (value instanceof Number) {
                row.createCell(counter.getAndIncrement(), CellType.NUMERIC).setCellValue(((Number) value).doubleValue());
            } else if (value instanceof Boolean) {
                row.createCell(counter.getAndIncrement(), CellType.BOOLEAN).setCellValue((Boolean) value);
            } else if (value instanceof Date) {
                row.createCell(counter.getAndIncrement(), CellType.NUMERIC).setCellValue((Date) value);
            } else if (value instanceof Calendar) {
                row.createCell(counter.getAndIncrement(), CellType.NUMERIC).setCellValue((Calendar) value);
            } else {
                row.createCell(counter.getAndIncrement(), CellType.ERROR);
            }
        } else {
            row.createCell(counter.getAndIncrement(), CellType.BLANK);
        }
    });
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
@Override
public String extract() throws ExtractorException {
    if (row == null)
        throw new BlankCellException("Empty row");
    if (row.getCell(columnId) == null)
        throw new ExtractorException("Column with index "+columnId+" does not exit");
    if (row.getCell(columnId).getCellTypeEnum() == CellType.BLANK)
        throw new BlankCellException("Empty cell value");
    try{
        switch (cellType) {
            case BOOLEAN:
                return String.valueOf(row.getCell(columnId).getBooleanCellValue());
            case NUMERIC:
                return String.valueOf(row.getCell(columnId).getNumericCellValue());
            case STRING:
                return String.valueOf(row.getCell(columnId).getStringCellValue());
            default:
                throw new ExtractorException("Unhandled cell type: "+cellType);
        }
    }catch (IllegalStateException e){
        // Most likely trying to read a non-numeric value like '--'
        // Hence we treat this as a blank cell
        throw new BlankCellException("Could not extract value", e);
    }
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
public CellSettings(
	CellType cellType,
	HSSFCellStyle cellStyle,
	Object cellValue,
	String formula,
	Hyperlink link
	) 
{
	this.cellType = cellType;
	this.cellStyle = cellStyle;
	this.cellValue = cellValue;
	this.formula = formula;
	this.link = link;
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
public void importValues(				
	CellType cellType,
	HSSFCellStyle cellStyle,
	Object cellValue,
	String formula,
	Hyperlink link
	) 
{
	this.cellType = cellType;
	this.cellStyle = cellStyle;
	this.cellValue = cellValue;
	this.formula = formula;
	this.link = link;
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
public static String getStringValue(Cell cell) {
	switch (cell.getCellTypeEnum()) {
	case BOOLEAN:
		return cell.getBooleanCellValue() ? "1" : "0";
	case FORMULA:
		return cell.getCellFormula();
	case NUMERIC:
		cell.setCellType(CellType.STRING);
		return cell.getStringCellValue();
	case STRING:
		return cell.getStringCellValue();
	default:
		return "";
	}

}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * Get Cell Data
 * 
 * @param cell
 * @return cellData
 */
@SuppressWarnings("deprecation")
private String getCellData(Cell cell) {
    /* Return Cell Type */
    CellType cellType = cell.getCellTypeEnum();

    /* Get Data */
    switch (cellType) {
        case BOOLEAN:
            return String.valueOf(cell.getBooleanCellValue());

        case NUMERIC:
            return String.valueOf(cell.getNumericCellValue());

        case STRING:
            return cell.getStringCellValue();

        case BLANK:
            return new String();

        default:
            return new String();
    }
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
public ExpowCellLib(int rowIndex, int columnIndex, CellType cellType, String value) {
	// 
	this.x = columnIndex; 
	this.y = rowIndex; 
	this.value = value;
	this.type = cellType;
	if (getCellTypeAsStr().equals(BadCellType)) {
		throw new IllegalArgumentException(
				String.format("Cell type is not valid:%d", 
						cellType));
	}
	
	if (value == null) {
		throw new IllegalArgumentException(
				String.format("Cell value can't be null."));
	}
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
@Test
public void testGetCellTypeAsStr() throws Exception {
	//
	ExpowCellLib cell = new ExpowCellLib(0, 0, CellType.STRING, "StringValue"); 
	assertEquals("CELL_TYPE_STRING", cell.getCellTypeAsStr());
	
	cell = new ExpowCellLib(0, 0, CellType.BLANK, ""); 
	assertEquals("CELL_TYPE_BLANK", cell.getCellTypeAsStr());

	cell = new ExpowCellLib(0, 0, CellType.BOOLEAN, "true"); 
	assertEquals("CELL_TYPE_BOOLEAN", cell.getCellTypeAsStr()); 

	cell = new ExpowCellLib(0, 0, CellType.ERROR, ""); 
	assertEquals("CELL_TYPE_ERROR", cell.getCellTypeAsStr());

	cell = new ExpowCellLib(0, 0, CellType.FORMULA, ""); 
	assertEquals("CELL_TYPE_FORMULA", cell.getCellTypeAsStr());
	
	cell = new ExpowCellLib(0, 0, CellType.NUMERIC, ""); 
	assertEquals("CELL_TYPE_NUMERIC", cell.getCellTypeAsStr());
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * 行単位で解析し、必要なら改ページを挿入する
 */
protected void parseRow( Sheet sheet, SheetParser sheetParser, SheetData sheetData, Row row, int rowIndex) {
    int firstColNum = row.getFirstCellNum();
    int lastColNum = row.getLastCellNum() - 1;

    for ( int colIndex = firstColNum; colIndex <= lastColNum; colIndex++) {
        Cell cell = row.getCell( colIndex);
        if ( cell != null) {
            if ( cell.getCellTypeEnum() == CellType.STRING && cell.getStringCellValue().contains( BreakParamParser.DEFAULT_TAG)) {
                // 改ページを挿入
                if ( isInMergedRegion( sheet, row, cell)) {
                    setRowBreakMergedRegion( sheet, row, cell);
                } else {
                    setRowBreak( sheet, row, cell);
                }
            }
        }
    }

}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * 対象シートの指定された範囲のセルのタイプint[行番号][列番号]の形式で取得する。 セルの値がnullの場合、Cell.CELL_TYPE_BLANKがセットされる。
 * 
 * @param sheet 対象となるシート
 * @param bStartRowIndex 範囲開始行番号
 * @param bEndRowIndex 範囲終了行番号
 * @param bStartColIndex 範囲開始列番号
 * @param bEndColIndex 範囲終了列番号
 * @return セルのタイプ
 */
public static CellType[][] getBlockCellType( Sheet sheet, int bStartRowIndex, int bEndRowIndex, int bStartColIndex, int bEndColIndex) {
    CellType[][] blockCellType = new CellType[bEndRowIndex - bStartRowIndex + 1][bEndColIndex - bStartColIndex + 1];
    int rowIdx = 0;
    for ( int bRowIndex = bStartRowIndex; bRowIndex <= bEndRowIndex; bRowIndex++) {
        int colIdx = 0;
        for ( int bColIndex = bStartColIndex; bColIndex <= bEndColIndex; bColIndex++) {
            Row row = sheet.getRow( bRowIndex);
            if ( row != null && row.getCell( bColIndex) != null) {
                blockCellType[rowIdx][colIdx] = row.getCell( bColIndex).getCellTypeEnum();
            } else {
                blockCellType[rowIdx][colIdx] = CellType.BLANK;
            }

            colIdx++;
        }
        rowIdx++;
    }

    return blockCellType;
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * 行に情報(値、スタイル、タイプ)が設定されているかどうかの判定を行う
 * 
 * @param rowCellTypes 対象行のセルスタイル
 * @param rowCellValues 対象行のセルの値
 * @param rowCellStyles 対象行のセルタイプ
 * @return 行が空の場合はtrue、行に何らかの情報を持っている場合はfalse
 */
public static boolean isEmptyRow( CellType[] rowCellTypes, Object[] rowCellValues, CellStyle[] rowCellStyles) {
    // CellTypeの空判定 BLANKなら空とみなす
    for ( CellType cellType : rowCellTypes) {
        if ( cellType != CellType.BLANK) {
            return false;
        }
    }

    // 値の空判定 nullなら空とみなす
    for ( Object cellValue : rowCellValues) {
        if ( cellValue != null) {
            return false;
        }
    }

    // CellStyleの空判定 nullなら空とみなす
    for ( CellStyle cellStyle : rowCellStyles) {
        if ( cellStyle != null) {
            return false;
        }
    }
    return true;
}
 

import org.apache.poi.ss.usermodel.CellType; //导入依赖的package包/类
/**
 * セルに情報(値、スタイル、タイプ)が設定されているかどうかの判定を行う
 * 
 * @param cellType 対象セルのスタイル
 * @param cellValue 対象セルの値
 * @param cellStyle 対象セルのタイプ
 * @return セルが空の場合はtrue、セルに何らかの情報を持っている場合はfalse
 */
public static boolean isEmptyCell( CellType cellType, Object cellValue, CellStyle cellStyle) {
    // CellTypeの空判定 BLANKなら空とみなす
    if ( cellType != CellType.BLANK) {
        return false;
    }

    // 値の空判定 nullなら空とみなす
    if ( cellValue != null) {
        return false;
    }

    // CellStyleの空判定 nullなら空とみなす
    if ( cellStyle != null) {
        return false;
    }
    return true;
}