ExcelDNA Addin Installation

60 views
Skip to first unread message

Roy

unread,
May 22, 2024, 7:11:33 AMMay 22
to Excel-DNA
Hi Govert,

Apologies for a very basic question but I am having trouble installing ExcelDNA Addin for some reason. I have been following your Youtube tutorials, tried multiple times but am getting the following error message:

Error The imported project file "C:\Users\Roy\source\repos\ClassLibrary1\packages\ExcelDna.AddIn.1.8.0\build\ExcelDna.AddIn.targets" could not be loaded. Name cannot begin with the '<' character, hexadecimal value 0x3C. Line 221, position 98. C:\Users\Roy\source\repos\ClassLibrary1\ClassLibrary1.vbproj

Do you mind advising? Thanks a lot for your help and time in advance.

Kind Regards,
Roy

Govert van Drimmelen

unread,
May 22, 2024, 7:31:04 AMMay 22
to Excel-DNA
Hi Roy,

What version of Visual Studio are you using?
This is the simplest add-in with VB.NET - maybe you can check whether it compiles on your machine.

-Govert

Roy

unread,
May 22, 2024, 7:40:21 AMMay 22
to Excel-DNA
Hi Govert,

I am using Visual Studio 2022. I tried your suggestion but still getting an error. Is this error only happening to me?

Error (active) Project "C:\Users\Roy\.nuget\packages\exceldna.addin\1.8.0\build\ExcelDna.AddIn.targets" was not imported by "C:\Users\Roy\Downloads\TestVb18-master\TestVb18-master\TestVb18\obj\TestVb18.vbproj.nuget.g.targets" at (4,5), due to the file being invalid.

Error (active) MSB4024 The imported project file "C:\Users\Roy\.nuget\packages\exceldna.addin\1.8.0\build\ExcelDna.AddIn.targets" could not be loaded. Name cannot begin with the '<' character, hexadecimal value 0x3C. Line 221, position 98. TestVb18 C:\Users\Roy\Downloads\TestVb18-master\TestVb18-master\TestVb18\obj\TestVb18.vbproj.nuget.g.targets 4

Kind Regards,
Roy

Govert van Drimmelen

unread,
May 22, 2024, 8:59:08 AMMay 22
to exce...@googlegroups.com

Hi Roy,

 

It works fine on my machine,  and I’ve had no other reports of this error or build trouble with this version (or earlier versions).

 

You can try:

*Delete the NuGet package from the cache - you can safely delete the whole directory C:\Users\Roy\.nuget\packages\exceldna.addin\1.8.0 Then rebuild.

*Reference an older version of the ExcelDna.AddIn Nuget package, maybe v1.7.0

*Maybe something on your machine is interpreting the xml files in a different way.The error you show relates to a line in the project file that has an &lt; escaped identifier. Not sure why that would be interpreted differently on your build.

 

The file and line mentioned looks like this on my machine:

 

 

Maybe you have some other tool installed in Visual Studio that might be interefering?

 

-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/f82543c4-9bc3-4be2-83fe-1527d1d829e8n%40googlegroups.com.

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