ExcelDna.Integration.dll not found

297 views
Skip to first unread message

Johan A

unread,
Oct 26, 2021, 5:46:40 AM10/26/21
to Excel-DNA
Hi,

I have MSTest test project (.NET Framework 4.8) where I test the UDF functions I have created in a ExcelDNA project.

I recently updated all Nuget packages related to ExcelDNA to latest stable release (1.5).

Now whatever test I run I get this error:  
System.IO.FileNotFoundException: Could not load file or assembly 'ExcelDna.Integration, Version=1.1.0.0, Culture=neutral, PublicKeyToken=f225e9659857edbe' or one of its dependencies. The system cannot find the file specified.

What could be wrong?


Govert van Drimmelen

unread,
Oct 26, 2021, 6:31:16 AM10/26/21
to exce...@googlegroups.com
Hi Johan

It looks like your project is still referencing the old version of ExcelDna.Integration. Maybe you can just check whether it is directly referencing the library, and thus not updated through the NuGet update.

Also, some of the additional Excel-Dna packages have not been updated yet (like ExcelDnaDoc) so maybe that causes trouble.

,-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/89255463-2477-482e-a4a9-f228c7a5a8f4n%40googlegroups.com.

Johan A

unread,
Oct 26, 2021, 7:08:21 AM10/26/21
to exce...@googlegroups.com
Hi Govert!

Thanks, I did not somehow spot that it complained about version 1.1.0.0.

I uninstalled and installed again all ExcelDna packages and this is what I have in the project file:

<ItemGroup>
    <Reference Include="ExcelDna.Documentation, Version=0.2.3.0, Culture=neutral, processorArchitecture=MSIL">
      <HintPath>..\packages\ExcelDnaDoc.0.2.3\lib\net40\ExcelDna.Documentation.dll</HintPath>
    </Reference>
    <Reference Include="ExcelDna.Integration, Version=1.1.0.0, Culture=neutral, PublicKeyToken=f225e9659857edbe, processorArchitecture=MSIL">
      <HintPath>..\packages\ExcelDna.Integration.1.5.0\lib\net452\ExcelDna.Integration.dll</HintPath>
    </Reference>
    <Reference Include="ExcelDna.IntelliSense, Version=1.4.4.0, Culture=neutral, PublicKeyToken=f225e9659857edbe, processorArchitecture=MSIL">
      <HintPath>..\packages\ExcelDna.IntelliSense.1.5.0\lib\net452\ExcelDna.IntelliSense.dll</HintPath>
    </Reference>
    <Reference Include="ExcelDna.Registration, Version=1.1.0.0, Culture=neutral, PublicKeyToken=f225e9659857edbe, processorArchitecture=MSIL">
      <HintPath>..\packages\ExcelDna.Registration.1.5.0\lib\net452\ExcelDna.Registration.dll</HintPath>
    </Reference>
    <Reference Include="Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c, processorArchitecture=MSIL">
      <HintPath>..\packages\ExcelDna.Interop.14.0.1\lib\Microsoft.Office.Interop.Excel.dll</HintPath>
      <EmbedInteropTypes>True</EmbedInteropTypes>
    </Reference>
    <Reference Include="Microsoft.Vbe.Interop, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c, processorArchitecture=MSIL">
      <HintPath>..\packages\ExcelDna.Interop.14.0.1\lib\Microsoft.Vbe.Interop.dll</HintPath>
      <EmbedInteropTypes>True</EmbedInteropTypes>
    </Reference>
    <Reference Include="Office, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c, processorArchitecture=MSIL">
      <HintPath>..\packages\ExcelDna.Interop.14.0.1\lib\Office.dll</HintPath>
      <EmbedInteropTypes>True</EmbedInteropTypes>
    </Reference>

It's strange that ExcelDna.Integration still believes it's version 1.1.0.0

Br,
Johan





You received this message because you are subscribed to a topic in the Google Groups "Excel-DNA" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/exceldna/JmueUBhYoLg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/CABCjBXMfbzjzdCFfzpnb_6_9J9DrHDXOHM7C4axoCxOvHmgnsg%40mail.gmail.com.

Govert van Drimmelen

unread,
Oct 26, 2021, 8:27:12 AM10/26/21
to exce...@googlegroups.com

Hi Johan,

 

The version it will show for ExcelDna.Integration.dll will stay at 1.1.0 – this version is frozen to support “signed” assemblies.

 

Using ExcelDnaDoc is probably the problem – I’ll try to update it soon.

 

-Govert

Johan A

unread,
Oct 26, 2021, 10:11:05 AM10/26/21
to exce...@googlegroups.com
What's the latest version of ExcelDna that is working properly with ExcelDnaDoc?

When I updated to later versions (>=1.1) ExcelDna didn't recognize the ExcelFunctionDoc attribute anymore. Has something changed? Or is that due to the conflict with ExcelDnaDoc?

Br
Johan



Reply all
Reply to author
Forward
0 new messages