ICustomFunction usage with python

[666github666]

Hi, can you share example usage of ICustomFunction implementation?
I have found one example for python via Java but nothing for .NET

[amjad-sahi]

@666github666,

Please see the document with example code on ICustomFunction feature for your reference. The sample code is in .NET but you may easily convert it to Python. Please note, Aspose.Cells for Python via .NET is very similar to Aspose.Cells for .NET. So, you can refer to the docs.

Should you have further queries or issue, you may also post in dedicated forums.

[666github666]

Thanks, I was trying to do that but looks like I'm missing something. Here is my sample class implementation.

`class CustomCalcImpl(ICustomFunction):

def calculate_custom_function(self, function_name, params_list, context_objects):

    a = 4
    b = 4

    return a*b`

And how I use it:
workbook = Workbook("HelloWorld.xlsx") workbook.calculate_formula(False, CustomCalcImpl())

But get error:

class CustomCalcImpl(ICustomFunction): TypeError: type 'aspose.cells.ICustomFunction' is not an acceptable base type

Whole code:

`
from aspose.cells import Workbook, ICustomFunction

class CustomCalcImpl(ICustomFunction):

def calculate_custom_function(self, function_name, params_list, context_objects):

    a = 4
    b = 4

    return a*b

if name == 'main':

workbook = Workbook()
workbook.calculate_formula(False, CustomCalcImpl())`

[amjad-sahi]

Please import and implement ICustomFunction at the start of your program. Please do it properly and accordingly in your code for Python via .NET.