Class FunctionEval


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

      • functions

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

      • 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 function 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