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:


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



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


Here is the sample for your reference:


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