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: