To report a found bug,
please, select the text with the bug and click Report a Bug or
CTRL+ENTER.
Help
system 10.5 of 04/10/2024,
©
FORESIGHT
PythonInvokeModule(ModuleId,FunctionName,Param,…)
ModuleId. Identifier of the unit containing a function.
FunctionName. Function name.
Param1, Param2, …, ParamN. Function parameter.
NOTE. To define the parameter, specify either the number or the address of the cell where it is located.
It returns function execution result stored in the Python module.
NOTE. Before using the functions written in the Python language, make sure that integration is executed between Python and Foresight Analytics Platform.
The function can contain several parameters. New formulas are added automatically in the formula wizard after the user puts the cursor into the field with parameter. If extra parameters are added, they should be left empty. If the function contains no parameters, leave the Param field empty.
Keep in mind the following when calling a Python function:
Unit name and function name are case-sensitive. Unit name is specified without the .py extension.
The module where function is located must be copied to the Foresight Analytics Platform installation folder or must be imported to the Python library.
Parameters of the function and returned result must have one of the following data types: Null, Boolean, Integer, Double, Decimal (applied only to the result returned by the function), String.
If input and output operations are used in the module, then use the mechanism of critical sections for them.
TIP. For details on writing functions in the Python language and on import of modules into the Python library, see Python documentation.
Consider the Python code contained in the Python module with the MOD_PYT identifier:
def calculate(a, b)
return b%a+a
def check(value)
if (value>1000):
return 1
else
return 0
The table contains examples of formulas using the PythonInvokeModule function:
| Formula | Result | Description |
| =PythonInvokeModule("MOD_PYT", "calculate", 4, 40) | 4 | Calling the calculate function from the Python module in repository with the MOD_PYT identifier. Fixed values are sent as parameters values. |
| =PythonInvokeModule("MOD_PYT", "check", C3) | 1 OR 0 | Calling the check function from the Python module in repository with the MOD_PYT identifier. The C3 cell value is sent as parameter value. If the cell value is greater than 1000, then 1 is returned, otherwise - 0. |
See also:
Function Wizard │ Functions for Working with Python