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
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

Comments (0)