Java FormulaParseException类代码示例

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
protected void createName(HandlerState state, String bookmark, int row1, int col1, int row2, int col2 ) {
	CellReference crFirst = new CellReference( state.currentSheet.getSheetName(), row1, col1, true, true );
	CellReference crLast = new CellReference( row2, col2, true, true );
	String formula = crFirst.formatAsString() + ":" + crLast.formatAsString();

	Name name = state.currentSheet.getWorkbook().getName(bookmark);
	if( name == null ) {
		name = state.currentSheet.getWorkbook().createName();
		name.setNameName( bookmark ); 
		name.setRefersToFormula( formula );
	} else {
		String existingFormula = name.getRefersToFormula();
		try {
			name.setRefersToFormula(existingFormula + "," + formula);
		} catch( FormulaParseException ex ) {
			log.warn( 0, "Unable to add \"" + formula + "\" to name (\"" + bookmark + "\") with existing formula: " + existingFormula, ex );
		}
	}
}
 

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
/**
 * Extracts {@link IDataModel} from {@link Workbook} for given function name.
 * Useful for formula with particular functions. Does scan IDataModel for exact formula use and create new 
 * {@link IDataModel} for every formula found.
 */
static List<IDataModel> toDataModels(final Workbook book, final String function) {
    if (book == null || function == null) { return emptyList(); }
    List<IDataModel> list = new LinkedList<>();

    final FormulaParsingWorkbook parsingBook = create((XSSFWorkbook) book);
    
    Sheet s = book.getSheetAt(0); /* TODO: only one sheet is supported */
    for (Row r : s) {
        for (Cell c : r) {
            if (c == null || CELL_TYPE_FORMULA != c.getCellType()) { continue; }

            try {
                if (ConverterUtils.isFunctionInFormula(c.getCellFormula(), function))
                    { list.add(createDataModelFromCell(s, parsingBook, fromRowColumn(c.getRowIndex(), c.getColumnIndex()))); } }
            catch (FormulaParseException e) { log.warn("Warning while parsing excel formula. Probably this is OK.", e); }
        }
    }
    
    return list;
}
 

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
/**
 * セルに数式を設定する。
 * @since 1.5
 * 
 * @param adaptor フィールド
 * @param formulaAnno 数式定義用のアノテーション。
 * @param config システム設定。
 * @param cell 設定対象のセル。
 * @param targetBean 処理対象のJavaBean.
 * @throws XlsMapperException
 */
public static void setupCellFormula(final FieldAdaptor adaptor, final XlsFormula formulaAnno, final XlsMapperConfig config, 
        final Cell cell, final Object targetBean) throws XlsMapperException {
    
    ArgUtils.notNull(adaptor, "adaptor");
    ArgUtils.notNull(formulaAnno, "formulaAnno");
    ArgUtils.notNull(config, "config");
    ArgUtils.notNull(cell, "cell");
    
    final String formula = getFormulaValue(adaptor, formulaAnno, config, cell, targetBean);
    if(isEmpty(formula)) {
        cell.setCellType(Cell.CELL_TYPE_BLANK);
        return;
    }
    
    try {
        cell.setCellFormula(formula);
        cell.setCellType(Cell.CELL_TYPE_FORMULA);
        
    } catch(FormulaParseException e) {
        // 数式の解析に失敗した場合
        final String message = new StringBuilder()
                .append(String.format("Fail parse formula '%s'.", formula))
                .append(String.format(" Cell '%s' map from '%s#%s'.", 
                        formatCellAddress(cell), adaptor.getDeclaringClass().getName(), adaptor.getName()))
                .toString();
            
        throw new ConversionException(message, e, adaptor.getTargetClass());
    }
}
 

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
public void setCellSubtitle(int row, int column, String location, String strTo, String strFrom) throws FormulaParseException, Exception {
	String subTitle = "SUBSTITUTE(PROPER(" + location + ")," + strTo + "," + strFrom + ")";
	this.getCell(row, column).setCellFormula(subTitle);
}
 

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
@Override
public IExecutionGraph buildExecutionGraph(IA1Address cell, ExecutionGraphConfig config) {
    try {
        this.graphLock.lock();
        log.debug("Building Graph for address: {}.", cell);
        
        /* Clear POI cache to allow graph building to be full */
        this.evaluator.poiEvaluator.clearAllCachedResultValues();
                    
        PoiExecutionGraphBuilder graphBuilder = new PoiExecutionGraphBuilder(config);
        this.evaluator.setExecutionGraphBuilder(graphBuilder);
        
        try {
            IEvaluationResult<ICellValue> res = this.evaluator.evaluate(cell);
            
            if (res == null || res.getResult() == null || res.getResult().get() == null) 
                { return buildSingleVertexGraphForEmptyCell(cell); }

            ICellValue cv = res.getResult();
            
            graphBuilder.runPostProcessing(false);
            ExecutionGraph g = graphBuilder.getGraph();
            
            if (g.getVertices().isEmpty()) { return buildSingleVertexGraphForCellWithValue(cv, new CellAddress(this.evaluator.model.getDataModelId(), cell)); }
            if (g.getVertices().size() == 1) {
                if (VALUE_INVALID.getErrorString().equals(cv.get()))
                    { return buildSingleVertexGraphForParseException(new CellAddress(this.evaluator.model.getDataModelId(), cell), VALUE_INVALID, null); }
                if (NAME_INVALID.getErrorString().equals(cv.get()))
                    { return buildSingleVertexGraphForParseException(new CellAddress(this.evaluator.model.getDataModelId(), cell), NAME_INVALID, null); }
            }
            
            return g;
        } catch (FormulaParseException | IncorrectExternalReferenceException e) {
            log.warn("Caught exception while building a graph, but the graph should be ok.", e);
            return graphBuilder.getGraph();
        }
    } finally {
        this.graphLock.unlock();
        log.debug("Building Graph for address: {} is finished.", cell);
    }
}
 

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
/** Returns true if value string is formula */
static boolean isFormula(String value, EvaluationWorkbook workbook) {
    try { return FormulaParser.parse(value, (FormulaParsingWorkbook) workbook, 0, 0).length > 1; } // TODO: formulaType and sheet index are 0
    catch (FormulaParseException e) { return false; }
}
 

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
public void setCellFormula(String formula) throws FormulaParseException {
	throw new IllegalStateException("CellClone is not support setCellFormula(String formula).");
}
 

import org.apache.poi.ss.formula.FormulaParseException; //导入依赖的package包/类
/**
 * Not supported
 */
@Override
public void setCellFormula(String formula) throws FormulaParseException {
  throw new NotSupportedException();
}