org.zkoss.poi.ss.formula.atp

Class AnalysisToolPak

java.lang.Object

org.zkoss.poi.ss.formula.atp.AnalysisToolPak

All Implemented Interfaces:

UDFFinder

public final class AnalysisToolPak
extends Object
implements UDFFinder

Author:

Josh Micich, Petr Udalau - systematized work of add-in libraries and user defined functions.

Field Summary

Fields

Modifier and Type	Field and Description
static UDFFinder	instance

Fields inherited from interface org.zkoss.poi.ss.formula.udf.UDFFinder

DEFAULT

Method Summary

Modifier and Type	Method and Description
FreeRefFunction	findFunction(String name) Returns executor by specified name.
static Collection<String>	getNotSupportedFunctionNames() Returns a collection of ATP function names NOT implemented by POI.
static Collection<String>	getSupportedFunctionNames() Returns a collection of ATP function names implemented by POI.
static boolean	isATPFunction(String name)
static void	registerFunction(String name, FreeRefFunction func) Register a ATP function in runtime.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

instance

public static final UDFFinder instance

Method Detail

findFunction

public FreeRefFunction findFunction(String name)

Description copied from interface: UDFFinder

Returns executor by specified name. Returns null if the function name is unknown.

Specified by:

findFunction in interface UDFFinder

Parameters:

name - Name of function.

Returns:

Function executor.

isATPFunction

public static boolean isATPFunction(String name)

getSupportedFunctionNames

public static Collection<String> getSupportedFunctionNames()

Returns a collection of ATP function names implemented by POI.

Returns:

an array of supported functions

Since:

3.8 beta6

getNotSupportedFunctionNames

public static Collection<String> getNotSupportedFunctionNames()

Returns a collection of ATP function names NOT implemented by POI.

Returns:

an array of not supported functions

Since:

3.8 beta6

registerFunction

public static void registerFunction(String name,
                                    FreeRefFunction func)

Register a ATP 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