Articles in this section
Category / Section

How can we add Custom Add-In function in XlsIO?

1 min read

In order to make XlsIO to use unknown function/Add-ins like Bloomberg, we need to register it as custom add-in function and make XlsIO to recognize it and use these functions as formulas in XlsIO. We can do that by using the following code:

C#

IAddInFunctions unknownFunctions = workbook.AddInFunctions;
unknownFunctions.Add( "blp" );
//Use Function
sheet.Range[ "A3" ].Formula = "blp(A1+\" CORP\",\"PX_LAST\")";

 

VB

Dim unknownFunctions As IAddInFunctions = workbook.AddInFunctions
unknownFunctions.Add("blp")
'Use Function
 sheet.Range("A3").Formula = "blp(A1+"" CORP"",""PX_LAST"")"

 

Here is the sample for your reference:

XLSIO_AddIn_Function.zip

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied