xll not linked to dll

34 views
Skip to first unread message

Aurélien Mondinot

unread,
Jan 7, 2022, 8:11:17 AMJan 7
to Excel-DNA

Dear Mr Govert,

Thank you very much for the time spent answering our questions and best wishes for the year to come. I am new to Excel Dna.

I have a question :

I have a library that produces a dll file whenever I press run.

I also have a .dna that indicates where this .dll is located.

However, the xll file does not update itself. I figure that the dll file is not found.

Thus, I cannot use the added c# functions on excel as they are not in the xll.

Do you have any idea of how I could fix this problem ?

By the way, I am using v1.0.

Thank you very much.

Govert van Drimmelen

unread,
Jan 7, 2022, 8:46:39 AMJan 7
to exce...@googlegroups.com

I presume you have the ExcelDna.AddIn package from NuGet installed in your project.

 

It might be that the build tasks of the NuGet package are not running correctly.

This happens most often if the package is installed as a <PackageReferece> in the project file, and not in a separate packages.config file.

Which way this happens depends on some Visual Studio settings.

I think from Excel-DNA v 1.1 it checks for this and gives an error when building.

 

I suggest:

 

  1. you check that the Visual Studio option to use “packages.config” is set:

 

  1. Then  make a new project that is a “Class Library (.NET Framework)” type – the “.NET Framework” is important here.
  2. Install the ExcelDna.AddIn package from NuGet.
  3. Check that you get a .dna file and then when you build you get the .xll files in the output directory.
  4. Add simple function like in the readme.txt file and check that everything works.

 

 

Once a new project works fine you can try to figure out what is different with your project and why it might not work.

 

-Govert

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/4831581f-70a7-4c88-b0eb-bf8b621ba01an%40googlegroups.com.

image001.png
Reply all
Reply to author
Forward
0 new messages