/** * @param stabilityClassifier used to optimise caching performance. Pass <code>null</code> * for the (conservative) assumption that any cell may have its definition changed after * evaluation begins. * @param udfFinder pass <code>null</code> for default (AnalysisToolPak only) */ public static XSSFFormulaEvaluator create(XSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder) { return new XSSFFormulaEvaluator(workbook, stabilityClassifier, udfFinder); }
/** * Creates a XSSFFormulaEvaluator, the object that evaluates formula cells. * * @return a XSSFFormulaEvaluator instance */ @Override public XSSFFormulaEvaluator createFormulaEvaluator() { return new XSSFFormulaEvaluator(workbook); }
@Override protected FormulaEvaluator doWithXSSFWorkbook(XSSFWorkbook workbook) { return new XSSFFormulaEvaluator(workbook); } }.execute();
/** * Creates a XSSFFormulaEvaluator, the object that evaluates formula cells. * * @return a XSSFFormulaEvaluator instance */ @Override public XSSFFormulaEvaluator createFormulaEvaluator() { return new XSSFFormulaEvaluator(workbook); }
/** * Creates a XSSFFormulaEvaluator, the object that evaluates formula cells. * * @return a XSSFFormulaEvaluator instance */ public XSSFFormulaEvaluator createFormulaEvaluator() { return new XSSFFormulaEvaluator(workbook); }
/** * @param stabilityClassifier used to optimise caching performance. Pass <code>null</code> * for the (conservative) assumption that any cell may have its definition changed after * evaluation begins. * @param udfFinder pass <code>null</code> for default (AnalysisToolPak only) */ public static XSSFFormulaEvaluator create(XSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder) { return new XSSFFormulaEvaluator(workbook, stabilityClassifier, udfFinder); }
/** * @param stabilityClassifier used to optimise caching performance. Pass <code>null</code> * for the (conservative) assumption that any cell may have its definition changed after * evaluation begins. * @param udfFinder pass <code>null</code> for default (AnalysisToolPak only) */ public static XSSFFormulaEvaluator create(XSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder) { return new XSSFFormulaEvaluator(workbook, stabilityClassifier, udfFinder); }
/** * Returns a formula evaluator that is loaded with the functions that * have been supplied. * * @param fileName Specifies if XSSF or HSSF should be used for * the evaluator * @return A {@link FormulaEvaluator} constructed accordingly */ protected FormulaEvaluator getEvaluator(String fileName) { FormulaEvaluator evaluator; if (fileName.endsWith(".xlsx")) { if(xlsMacroList.size() > 0) { evaluator = XSSFFormulaEvaluator.create((XSSFWorkbook) workbook, null, getFunctions()); } evaluator = new XSSFFormulaEvaluator((XSSFWorkbook) workbook); } else { if(xlsMacroList.size() > 0) { evaluator = HSSFFormulaEvaluator.create((HSSFWorkbook)workbook, null, getFunctions()); } evaluator = new HSSFFormulaEvaluator((HSSFWorkbook) workbook); } return evaluator; }