We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Use Yield function of excel

Thread ID:





71824 Feb 14,2008 05:03 PM UTC Feb 16,2008 07:39 AM UTC WinForms 1
Tags: XlsIO
Sanjeev Soni
Asked On February 14, 2008 05:03 PM UTC


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.

-Sanjeev Soni

Yavanaarasi G [Syncfusion]
Replied On February 16, 2008 07:39 AM UTC

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:


Please let me know if this helps.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon