Evaluate AddIn Function

[Suranga R]

Hi Team,

Is it possible to evaluate/invoke AddIn Function via XlsIO?

I need to get a computed value by invoking an AddIn Function.

Documentation only describe how to create and 'use', but I'm not sure how to invoke it.

Thanks!

[Prakash Kumar D]

Hi Suranga, 

 

Thank you for contacting Syncfusion support. 

 

In XlsIO, we only have support for adding and creating the custom Add-In functions. However, you can use CalcEngine.ParseAndComputeFormula(string formula) method to get calculated value of a formula using custom function. We have shared a sample for your reference which can be downloaded from the following link.  

   

Sample link: http://www.syncfusion.com/downloads/support/directtrac/195667/ze/CreateSpreadSheet-1628097677   

   

Please try this and let us know if it helps.  

  

Note: This custom function will not work in Excel document.  

 

Regards, 

Prakash Kumar 

[Suranga R]

Hi Prakash,

Thanks for the confirmation.

Yes, I was already falling back to 'custom function' in case AddIn Functions are not supported.

Thank you very much!

[Dilli Babu Nandha Gopal]

Hi Suranga, 

 

Thank you for your update. 

 

Please let us know if you need further assistance on this. 

 

Regards, 

Dilli babu.