Class FunctionEval

java.lang.Object
org.apache.poi.ss.formula.eval.FunctionEval

public final class FunctionEval extends Object
Mappings from the Excel functions to our evaluation implementations (where available)
  • Field Details

    • functions

      protected static final Function[] functions
      Array elements corresponding to unimplemented functions are null
  • Method Details

    • getBasicFunction

      public static Function getBasicFunction(int functionIndex)
      Returns:
      null if the specified functionIndex is for INDIRECT() or any external (add-in) function.
    • registerFunction

      public static void registerFunction(String name, Function func)
      Register a new function in runtime.
      Parameters:
      name - the function name
      func - the functoin to register
      Throws:
      IllegalArgumentException - if the function is unknown or already registered.
      Since:
      3.8 beta6
    • getSupportedFunctionNames

      public static Collection<String> getSupportedFunctionNames()
      Returns a collection of function names implemented by POI.
      Returns:
      an array of supported functions
      Since:
      3.8 beta6
    • getNotSupportedFunctionNames

      public static Collection<String> getNotSupportedFunctionNames()
      Returns an array of function names NOT implemented by POI.
      Returns:
      an array of not supported functions
      Since:
      3.8 beta6