Use Yield function of excel

[Sanjeev Soni]

Hi,

I am trying to use the YIELD function of excel via syncfusion.XlsIO. But it is giving error "Yield isn't custom function"

I tried using microsoft excel object and found that i have to add the addin in my code
oXL.AddIns["Analysis ToolPak - VBA"].Installed = true;

Can you please let me know who i can make this work using SyncFusion object.

Thanks
-Sanjeev Soni

[Yavanaarasi G]

Hi sanjeev,

Thank you for your interest in Essential XlsIO.

In order to make XlsIO to use YIELD() function we need to register it as custom add-in function and make XlsIO also recognize it. We can do that by using the following code snippet:

//Define Function
IAddInFunctions unknownFunctions = workbook.AddInFunctions;
unknownFunctions.Add( "YIELD" );

//Use Function
sheet.Range[ "A3" ].Formula = "YIELD(A1+\" CORP\",\"PX_LAST\")";

Please refer the sample in the below link which illustrates the above:

http://websamples.syncfusion.com/samples/XlsIO.Windows/71824/main.htm

Please let me know if this helps.

Regards,
G.Yavana