sample VS2010 solution?

Aug 23, 2010 at 3:57 PM

sorry if this is dumb, but if there it exists I cannot find it. would it be possible to add a sample vs2010 solution, showing how to build an new xll (which uses  exceldna) in C#? I'd suggest to have in it just a few UDF functions.

As a user, I would then just change a few names and add the required .cs files.

thank you,

a.c.

Coordinator
Aug 24, 2010 at 7:42 AM

Hi,

I like your suggestion suggestion of adding a sample template for Visual Studio users to the distribution. In the Getting Started I explain how to create and expose a compiled library using the command-line compiler. For Visual Studio, you create a new C# library project, reference the file ExcelDna.Integration and add the content of TestLib.cs from the Getting Started step 3. 

Have you tried to make an Excel-Dna library with Visual Studio? Would you like to contribute a template of the type that would have helped you? 

I'm starting to shift my focus to the Excel-Dna Editor, which will be a customized IDE for making Excel-Dna add-ins.

Regards,

Govert

 

Aug 24, 2010 at 9:24 AM
Hi,
i have not used excelDna at all yet: so i do not think that it would be a good idea i contributed it, as I do not know what is the best way to set it up, and it would be unlikely to be the best way to do it.
It would be useful to have the VisualStudio template showing best practice.

By the way I am not sure I understand what the use of an Excel-Dna editor would be, at least for users of Visual Studio?

thanks and best regards,
a.c.

Coordinator
Aug 24, 2010 at 12:17 PM

Hi again,

Until we have a nice template:

Once you've worked through the Getting Started samples for Excel-Dna, you might find it useful to have a look at this (slightly out of date) description of how to get your project set up in Visual Studio. http://groups.google.com/group/exceldna/web/how-to-setup-vs-2005-to-be-able-to-use-breakpoints-in-your-addin. It seems the Files feature on Google Groups are currently broken, but I think the step-by-step description should help.

If you are compiling for .Net 2.0 you should also look at these posts to get the debugging working under Visual Studio 2010: http://groups.google.com/group/exceldna/browse_thread/thread/6767ac80f2bb3f11/0ed7258176144779?show_docid=0ed7258176144779.

And if you have any particular questions, please post back here of (preferably to the Google group: http://groups.google.com/group/exceldna).

 

The Excel-Dna Editor will target users who do not have Visual Studio, but might be using VBA at the moment. It will also provide a GUI for setting up the .dna files, and packing everything into a single-file .xll add-in for distribution, tasks which currently involve editing the xml content of the .dna file and running the command-line packing tool.

Cheers,

Govert

Coordinator
Aug 24, 2010 at 12:19 PM

A more recent step-by-step tutorial to get you started is here:

http://edparcell.posterous.com/tutorial-numerical-analysis-in-excel-using-c

Aug 24, 2010 at 3:41 PM
thank you - one more question please: does exceldna provide a way to link help to the functions? i.e. linking to the "help" link in the shift-f3 dialogue box.

PS: looking into excelDna because of Net 4 and (possibly) the above. we have been using xlw up to now, which is good but is not yet on Net 4, and does not have the "help" link

Coordinator
Aug 24, 2010 at 5:58 PM

Hi,

Ah - now I understand your original question better. I think the .Net support in XLW requires a few steps and for you to rebuild a C++ project, so a Visual Studio template is really important there. On the other hand, for Excel-Dna the .xll itself is not compiled per add-in; the only Visual Studio project you need for your add-in is just a vanilla C# library project, no special setting or anything, which explains why I have not been asked for this before. Adding a starter template is still a good idea, of course.

The HelpTopic is supported by Excel-Dna during function registration. But there is no automated help file generation - you need to make the help file yourself. There is a page on the Google group that talks about using the HelpTopic: http://groups.google.com/group/exceldna/web/helptopic, and you should search through the past discussions too: http://groups.google.com/group/exceldna/search?group=exceldna&q=helptopic&qt_g=Search+this+group.

Hope this gets you started. Please post back if you have any further questions.

Govert

 

Aug 24, 2010 at 6:38 PM
thanks again

Alberto Cherubini
EQ Finance Ltd
http://www.eqfltd.com/
+44 (0)7767 863 800


On 24 August 2010 18:58, govert <notifications@codeplex.com> wrote:

From: govert

Hi,

Ah - now I understand your original question better. I think the .Net support in XLW requires a few steps and for you to rebuild a C++ project, so a Visual Studio template is really important there. On the other hand, for Excel-Dna the .xll itself is not compiled per add-in; the only Visual Studio project you need for your add-in is just a vanilla C# library project, no special setting or anything, which explains why I have not been asked for this before. Adding a starter template is still a good idea, of course.

The HelpTopic is supported by Excel-Dna during function registration. But there is no automated help file generation - you need to make the help file yourself. There is a page on the Google group that talks about using the HelpTopic: http://groups.google.com/group/exceldna/web/helptopic, and you should search through the past discussions too: http://groups.google.com/group/exceldna/search?group=exceldna&q=helptopic&qt_g=Search+this+group.

Hope this gets you started. Please post back if you have any further questions.

Govert

 

Read the full discussion online.

To add a post to this discussion, reply to this email (exceldna@discussions.codeplex.com)

To start a new discussion for this project, email exceldna@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com