Implementing the Intellisense Example in Excel

147 views
Skip to first unread message

deron jones

unread,
Jul 23, 2018, 11:18:58 AM7/23/18
to Excel-DNA
Hi All

im new to excel DNA and I would like to implement and test the intellisense example. I was able to build the solution but im having trouble registering the 
.dll to run in Excel.

has anyone used this example in excel yet. can you tell me how to get it registered ?

regards
Deron Jones

Govert van Drimmelen

unread,
Jul 23, 2018, 11:31:39 AM7/23/18
to exce...@googlegroups.com
Hi Deron,

If you are rebuilding the IntelliSense solution (from here https://github.com/Excel-DNA/IntelliSense ) then you should run the Debug version found in bin\Debug\ExcelDna.IntelliSense.xll.
The debug version of the add-in has a few test functions, e.g. =AddThem(...) which will show IntelliSense.

If you have your own Excel-DNA add-in, then your functions should also light up if your have the add-in opened.
If you have VBA functions that you want to make IntelliSense for, you can follow the instruction from Charles Williams's write-up: https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/

-Govert

________________________________________
From: exce...@googlegroups.com [exce...@googlegroups.com] on behalf of deron jones [deronj...@gmail.com]
Sent: 23 July 2018 05:18 PM
To: Excel-DNA
Subject: [ExcelDna] Implementing the Intellisense Example in Excel
--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna+u...@googlegroups.com>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

deron jones

unread,
Jul 23, 2018, 11:44:11 AM7/23/18
to exce...@googlegroups.com
hi govert

I need to register the .dll correct ? im running the version from GitHub but I cant seem to get it registered properly after I build it. what are the steps needed
to get it to show in excel ?

I came from an Addins Express background so must of this is done for me in that tool.

thanks


On Mon, Jul 23, 2018 at 11:31 AM, Govert van Drimmelen <gov...@icon.co.za> wrote:
Hi Deron,

If you are rebuilding the IntelliSense solution (from here  https://github.com/Excel-DNA/IntelliSense ) then you should run the Debug version found in bin\Debug\ExcelDna.IntelliSense.xll.
The debug version of the add-in has a few test functions, e.g. =AddThem(...) which will show IntelliSense.

If you have your own Excel-DNA add-in, then your functions should also light up if your have the add-in opened.
If you have VBA functions that you want to make IntelliSense for, you can follow the instruction from Charles Williams's write-up: https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/

-Govert

________________________________________
From: exce...@googlegroups.com [exce...@googlegroups.com] on behalf of deron jones [deronj...@gmail.com]
Sent: 23 July 2018 05:18 PM
To: Excel-DNA
Subject: [ExcelDna] Implementing the Intellisense Example in Excel

Hi All

im new to excel DNA and I would like to implement and test the intellisense example. I was able to build the solution but im having trouble registering the
.dll to run in Excel.

has anyone used this example in excel yet. can you tell me how to get it registered ?

regards
Deron Jones


--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+unsubscribe@googlegroups.com<mailto:exceldna+unsubscribe@googlegroups.com>.
To post to this group, send email to exce...@googlegroups.com<mailto:exceldna@googlegroups.com>.
--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+unsubscribe@googlegroups.com.
To post to this group, send email to exce...@googlegroups.com.

Govert van Drimmelen

unread,
Jul 23, 2018, 12:25:19 PM7/23/18
to exce...@googlegroups.com
Hi Deron,

No - you must not register any .dll.

Where are the functions defined that you want to show IntelliSense for?
If they are in an Excel-DNA add-in, then the only steps you need to take is to download and File->Open the ExcelDna.IntelliSense.xll add-in from https://github.com/Excel-DNA/IntelliSense/releases
That should already work.
If you're happy that it's working right, you can then install the ExcelDna.IntelliSense.xll add-in to load at startup, by pressing "Alt+t, i" to open the add-ins dialog, browsing and adding from there.

-Govert


________________________________________
From: exce...@googlegroups.com [exce...@googlegroups.com] on behalf of deron jones [deronj...@gmail.com]
Sent: 23 July 2018 05:44 PM
To: exce...@googlegroups.com
Subject: Re: [ExcelDna] Implementing the Intellisense Example in Excel

hi govert

I need to register the .dll correct ? im running the version from GitHub but I cant seem to get it registered properly after I build it. what are the steps needed
to get it to show in excel ?

I came from an Addins Express background so must of this is done for me in that tool.

thanks


On Mon, Jul 23, 2018 at 11:31 AM, Govert van Drimmelen <gov...@icon.co.za<mailto:gov...@icon.co.za>> wrote:
Hi Deron,

If you are rebuilding the IntelliSense solution (from here https://github.com/Excel-DNA/IntelliSense ) then you should run the Debug version found in bin\Debug\ExcelDna.IntelliSense.xll.
The debug version of the add-in has a few test functions, e.g. =AddThem(...) which will show IntelliSense.

If you have your own Excel-DNA add-in, then your functions should also light up if your have the add-in opened.
If you have VBA functions that you want to make IntelliSense for, you can follow the instruction from Charles Williams's write-up: https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/

-Govert

________________________________________
From: exce...@googlegroups.com<mailto:exce...@googlegroups.com> [exce...@googlegroups.com<mailto:exce...@googlegroups.com>] on behalf of deron jones [deronj...@gmail.com<mailto:deronj...@gmail.com>]
Sent: 23 July 2018 05:18 PM
To: Excel-DNA
Subject: [ExcelDna] Implementing the Intellisense Example in Excel

Hi All

im new to excel DNA and I would like to implement and test the intellisense example. I was able to build the solution but im having trouble registering the
.dll to run in Excel.

has anyone used this example in excel yet. can you tell me how to get it registered ?

regards
Deron Jones


--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsu...@googlegroups.com><mailto:exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsu...@googlegroups.com>>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com><mailto:exce...@googlegroups.com<mailto:exce...@googlegroups.com>>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsu...@googlegroups.com>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna+u...@googlegroups.com>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com>.

deron jones

unread,
Jul 23, 2018, 12:48:48 PM7/23/18
to Excel-DNA
hi govert

I was able to get it to load. But my issue is with intellisense, I cant get it to work. I have this small code snippet.

namespace SimpleUDFToolTips
{
    using ExcelDna.Integration;
    using ExcelDna.IntelliSense;
    using ExcelDna.ComInterop;
    using System.Runtime.InteropServices;
    public static class MyFunctions
    {
        [ExcelFunction(Description = "My first .NET function")]
        public static string HelloDna(string name)
        {
            return "Hello " + name;
        }
        [ExcelFunction(Name = "DeronAdd", Description = "My first .NET function")]
        public static double DeronAdd(double x, double y)
        {
            return x + y;
        }
    }

and I thought it would show the description in the dropdown list for my udf when I type it in the formula bar in excel and it does not.

any ideas ?




On Monday, July 23, 2018 at 12:25:19 PM UTC-4, Govert van Drimmelen wrote:
Hi Deron,

No - you must not register any .dll.

Where are the functions defined that you want to show IntelliSense for?
If they are in an Excel-DNA add-in, then the only steps you need to take is to download and File->Open the ExcelDna.IntelliSense.xll add-in from https://github.com/Excel-DNA/IntelliSense/releases
That should already work.
If you're happy that it's working right, you can then install the ExcelDna.IntelliSense.xll add-in to load at startup, by pressing "Alt+t, i" to open the add-ins dialog, browsing and adding from there.

-Govert


________________________________________
From: exce...@googlegroups.com [exce...@googlegroups.com] on behalf of deron jones [deronj...@gmail.com]
Sent: 23 July 2018 05:44 PM
To: exce...@googlegroups.com
Subject: Re: [ExcelDna] Implementing the Intellisense Example in Excel

hi govert

I need to register the .dll correct ? im running the version from GitHub but I cant seem to get it registered properly after I build it. what are the steps needed
to get it to show in excel ?

I came from an Addins Express background so must of this is done for me in that tool.

thanks


On Mon, Jul 23, 2018 at 11:31 AM, Govert van Drimmelen <gov...@icon.co.za<mailto:gover...@icon.co.za>> wrote:
Hi Deron,

If you are rebuilding the IntelliSense solution (from here  https://github.com/Excel-DNA/IntelliSense ) then you should run the Debug version found in bin\Debug\ExcelDna.IntelliSense.xll.
The debug version of the add-in has a few test functions, e.g. =AddThem(...) which will show IntelliSense.

If you have your own Excel-DNA add-in, then your functions should also light up if your have the add-in opened.
If you have VBA functions that you want to make IntelliSense for, you can follow the instruction from Charles Williams's write-up: https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/

-Govert

________________________________________
From: exce...@googlegroups.com<mailto:exce...@googlegroups.com> [exce...@googlegroups.com<mailto:exce...@googlegroups.com>] on behalf of deron jones [deronj...@gmail.com<mailto:deronj...@gmail.com>]
Sent: 23 July 2018 05:18 PM
To: Excel-DNA
Subject: [ExcelDna] Implementing the Intellisense Example in Excel

Hi All

im new to excel DNA and I would like to implement and test the intellisense example. I was able to build the solution but im having trouble registering the
.dll to run in Excel.

has anyone used this example in excel yet. can you tell me how to get it registered ?

regards
Deron Jones


--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsubscribe@googlegroups.com><mailto:exceldna+unsub...@googlegroups.com<mailto:exceldna%2B...@googlegroups.com>>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com><mailto:exce...@googlegroups.com<mailto:exceldn...@googlegroups.com>>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsubscribe@googlegroups.com>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna+unsubscribe@googlegroups.com>.

Govert van Drimmelen

unread,
Jul 23, 2018, 12:52:21 PM7/23/18
to exce...@googlegroups.com
Have you doene File-> Open the ExcelDna.IntelliSense.xll that you download aded from Github?

-Govert
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To post to this group, send email to exce...@googlegroups.com.

deron jones

unread,
Jul 23, 2018, 1:20:45 PM7/23/18
to exce...@googlegroups.com
Hi

I was attempting to write a new xll from scratch . Do I need to create an xll file how is it created and implemented?




From: exce...@googlegroups.com <exce...@googlegroups.com> on behalf of Govert van Drimmelen <gov...@icon.co.za>
Sent: Monday, July 23, 2018 12:52:12 PM

Govert van Drimmelen

unread,
Jul 23, 2018, 4:02:29 PM7/23/18
to exce...@googlegroups.com
To make a basic Excel add-in with Excel-DNA, follow these steps:

* Create a new Class Library (.NET Framework) project.
* Install the ExcelDna.AddIn package from NuGet (I suggest you do the current pre-release version 0.35.4-beta4).
* Follow the instructions in the Readme that pops up, to create some function (your code posted earlier will also work fine)
* Press F5 to build and start debugging
* Check that your new functions work.

The end result in your output directory will include some .xll files. The basic 32-bit one is called <MyProject>-AddIn.xll. There is also an all-in-one .xll files called <MyProject>-AddIn-packed.xll

Now you have an .xll add-in that you can load on any Excel installation to get your functions.

If you then also load the pre-built ExcelDna.IntelliSense.xll add-in that you can download from GitHub ( https://github.com/Excel-DNA/IntelliSense/releases ) the IntelliSense for your functions will light up.


Once you have all of this working, we can consider further steps.

-Govert




Sent: 23 July 2018 07:20 PM

deron jones

unread,
Jul 23, 2018, 7:00:38 PM7/23/18
to exce...@googlegroups.com
thanks Govert It worked. 
I noticed that the argument tooltip in the xml did not work, it seems to only take argument tooltips from the actual function param definitions.

To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsu...@googlegroups.com><mailto:exceldna+unsubscribe@googlegroups.com<mailto:exceldna%2B...@googlegroups.com>>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com><mailto:exce...@googlegroups.com<mailto:exceldna@googlegroups.com>>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsu...@googlegroups.com>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna+unsubscribe@googlegroups.com>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+unsubscribe@googlegroups.com.

To post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+unsubscribe@googlegroups.com.

To post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+unsubscribe@googlegroups.com.

To post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+unsubscribe@googlegroups.com.

Govert van Drimmelen

unread,
Jul 24, 2018, 2:30:43 AM7/24/18
to exce...@googlegroups.com
Yes that's right - the C# <summary> style inline documentation is not used for Excel-DNA IntelliSense at all. 

-Govret



Sent: 24 July 2018 01:00 AM
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.

deron jones

unread,
Jul 24, 2018, 10:59:36 AM7/24/18
to exce...@googlegroups.com
actually it seems to only show the param help if its in c#. it does not show anything from the xml file.

To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsubscribe@googlegroups.com><mailto:exceldna+unsubscribe@googlegroups.com<mailto:exceldna%2B...@googlegroups.com>>.
To post to this group, send email to exce...@googlegroups.com<mailto:exce...@googlegroups.com><mailto:exce...@googlegroups.com<mailto:exceldna@googlegroups.com>>.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com<mailto:exceldna%2Bunsubscribe@googlegroups.com>.

Govert van Drimmelen

unread,
Jul 24, 2018, 11:07:25 AM7/24/18
to exce...@googlegroups.com
I'm not sure what xml file you're talking about.

You can make a special file with the name <MyAddIn>.intellisense.xml which is placed next to your add-in, and has the `<IntelliSense>` element. Such a file will override the descriptions from the [ExcelFunction(...)] attributes in the add-in.

Is that what you are trying to test now?

-Govert


Sent: 24 July 2018 04:59 PM
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.

deron jones

unread,
Jul 24, 2018, 11:23:07 AM7/24/18
to exce...@googlegroups.com
yes and it takes the instructions from the C# add-in code [ExcelFunction{}] and not from the special xml file. nothing worked until I downloaded the intellisense file from GitHub and created the special xml file, now it works but its taking the instructions from the c# code.

Govert van Drimmelen

unread,
Jul 24, 2018, 11:35:48 AM7/24/18
to exce...@googlegroups.com
Glad you got it working!

Yes - the simplest way to get the IntelliSense is to load the ExcelDna.IntelliSense.xll add-in that you download from the GitHub Releases tab.

For the external XXXXXXX.intellisense.xml file, you have to make sure it has the right name (and the right content) else it won't be used. It must exactly match the name of the .xll, except it must have ".intellisense.xml" instead of ".xll" at the end of the name.

-Govert


Sent: 24 July 2018 05:23 PM
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.

deron jones

unread,
Jul 24, 2018, 11:43:18 AM7/24/18
to exce...@googlegroups.com
yes thanks for your help.

yes that exactly what I have

deron jones

unread,
Jul 27, 2018, 3:59:56 PM7/27/18
to exce...@googlegroups.com
Hi Govert 

do you have an example project and/or the steps to implementing help using the exceldnadoc ? the website was not clear for me and im new to exceldna.

thanks
deron jones

Govert van Drimmelen

unread,
Jul 27, 2018, 5:52:44 PM7/27/18
to exce...@googlegroups.com
Hi Deron,

There are some sample projects for ExcelDnaDoc here: https://github.com/Excel-DNA/ExcelDnaDoc/tree/master/src/samples

-Govert



Sent: 27 July 2018 09:59 PM
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.

Govert van Drimmelen

unread,
Jul 27, 2018, 5:55:57 PM7/27/18
to Excel-DNA
Also the detailed documentation for ExcelDnaDoc is here: http://mndrake.github.io/ExcelDnaDoc/index.html

-Govert


On Friday, 27 July 2018 23:52:44 UTC+2, Govert van Drimmelen wrote:
Hi Deron,

Reply all
Reply to author
Forward
0 new messages