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

How to export user-defined function from grid to excel workbook?

In order to export user-defined formula library function from Grid to Excel, the following steps has to be followed.

  1. Create an Excel Add-In file (*.xla) including the user-defined function as illustrated in the following steps:
  • Create a new empty workbook and click Save As from the File menu.
  • In the Save As dialog box, select the location to save the workbook. Enter the file name for the Add-In workbook, and then select the type as Excel Add-In (*.xla).
  • Click Save, and then press ALT+ F11 to open the VBA Editor. Now, you can create the custom function through the VBA Editor by inserting a module.
  1. Now, bind add-in file path and custom method name with GridExcelConverterControl through AddCustomFunction method.

The following screenshot illustrates how to create the user-defined function through the VBA editor.

The XLA file will not be visible in Excel because Add-Ins are never visible. All changes must be done to the VBA Editor only.

VBA Coding

 

Code Snippet

C#

 

VB

 

Screenshot

Sample Link

C# CustomFunction_In_Excel_CS

VB CustomFunction_in_Excel_VB

Article ID: Published Date: Last Revised Date: Platform: Control:
5945 01/03/2016 02/08/2017 WinForms GridControl
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Please sign in to access our KB

or the page will be automatically redirected to 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