Table of Contents

XlsFile.EvaluateUserDefinedFunction Method

Evaluates a custom function you have added earlier with ExcelFile.AddUserDefinedFunction. You will not normally need to call this method, but it could be used for testing. If the function has not been added with ExcelFile.AddUserDefinedFunction, this method will return TFlxFormulaErrorValue.ErrName.

Syntax

Namespace: FlexCel.XlsAdapter

public override Object EvaluateUserDefinedFunction(String functionName, TUdfEventArgs arguments, Object[] parameters)

Parameters

<-> Parameter Type Description
functionName String Function you want to evaluate.
arguments TUdfEventArgs Extra arguments you can use to evaluate the formula.
parameters Object[] Parameters for the formula.

Returns

The result of evaluating the formula. It might be a string, a double, a boolean, a TFlxFormulaError or an Array.

See also