import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
@Override
public IRow readRow() {
	SheetData vData = getLocalData();
	int vRowIndex = vData.getCurrentIndex();
	if (vRowIndex < vData.getRowCount()) {
		Row vRow = vData.getSheet().getRow(vRowIndex);
		String[] vTitles = vData.getTitles();
		Cell[] vValues = new Cell[vTitles.length];
		for (int i = 0; i < vTitles.length; ++i) {
			Cell vCell = vRow.getCell(i, MissingCellPolicy.CREATE_NULL_AS_BLANK);
			vValues[i] = vCell;
		}
		vData.setCurrentIndex(vRowIndex + 1);
		return new RowExcelImpl(vRowIndex, vTitles, vValues);
	}
	// read over, remove the local data
	removeLocalData();
	return null;
}
 

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
private void setCellValue(final Object value, final int columnIndex) {
	Cell cell = currentExcelRow.getCell(
		sheetConfig.columnOrigin() + columnIndex,
		MissingCellPolicy.CREATE_NULL_AS_BLANK
	);
	sheetConfig.cellStyler().style(cell);

	if(value == null) {
		return;
	}

	// numbers
	if (value instanceof Integer) {
		cell.setCellValue(Double.valueOf(((Integer) value).intValue()));
	} else if (value instanceof Long) {
		cell.setCellValue(Double.valueOf(((Long) value).longValue()));
	} else if (value instanceof Float) {
		cell.setCellValue(Double.valueOf(((Float) value).floatValue()));
	} else if (value instanceof BigDecimal) {
		cell.setCellValue(((BigDecimal) value).doubleValue());
	} else if (value instanceof Double) {
		cell.setCellValue((Double) value);
	}
	// other types
	else if (value instanceof Boolean) {
		cell.setCellValue(((Boolean) value).booleanValue());
	} else if (value instanceof Calendar) {
		cell.setCellValue((Calendar) value);
	} else if (value instanceof Date) {
		cell.setCellValue((Date) value);
	} else if (value instanceof String) {
		cell.setCellValue((String) value);
	}

	else {
		cell.setCellValue(value.toString());
	}
}
 

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
@Override
public PoiCell getCell(int col) {
    org.apache.poi.ss.usermodel.Cell poiCell = poiRow.getCell(col, MissingCellPolicy.CREATE_NULL_AS_BLANK);
    return new PoiCell(this, poiCell);
}
 

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
/**
 * Not supported
 */
@Override
public MissingCellPolicy getMissingCellPolicy() {
    throw new UnsupportedOperationException();
}
 

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
/**
 * Not supported
 */
@Override
public void setMissingCellPolicy(MissingCellPolicy missingCellPolicy) {
    throw new UnsupportedOperationException();
}
 

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
/**
 * Not supported
 */
@Override
public MissingCellPolicy getMissingCellPolicy() {
  throw new UnsupportedOperationException();
}
 

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
/**
 * Not supported
 */
@Override
public void setMissingCellPolicy(MissingCellPolicy missingCellPolicy) {
  throw new UnsupportedOperationException();
}
 

import org.apache.poi.ss.usermodel.Row.MissingCellPolicy; //导入依赖的package包/类
public static Cell getCell(Row row, int col, MissingCellPolicy mcp) {
    if (row == null) {
        return null;
    }
    return row.getCell(col, mcp);
}