Dear developers,
I'm trying to follow the getting started "HelloDna" steps in the readme.txt created after running Install-Package ExcelDna.AddIn in the Nuget Package Console, but the HelloDna function is not being recognised by Excel when I run F5 to debug.
What I've done so far:
- Created new Class Library project targeting .NET.
- Installed ExcelDna.Addin Nuget package.
- Changed target framework to net6.0-windows in the .CSPROJ file.
- Created a new <PropertyGroup> with a <ExcelDnaAllowPackageReferenceProjectStyle> element, and set it to true in the .CSPROJ file.
- Created a new debug profile (executable) and set it to the Excel installation path.
- Created a new class with the sample C# function content.
- Hit F5 and prayed... but I just got Excel opened, without recognising the HelloDna function.
I also noticed that no .XLL file is being generated anywhere when I build or debug the project.
Any tips on what am I missing, or where should I look for a getting started using .NET 6?
Thanks.