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.
Unfortunately, activation email could not send to your email. Please try again.

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 Windows Forms GridControl
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.