Skip to content

VS extension v1.0.0

Choose a tag to compare

@Sergey-Vlasov Sergey-Vlasov released this 09 Aug 05:12
· 98 commits to master since this release

I've created the first version of the Excel-DNA Developer Tools extension:

installed-extension

It includes C# and VB project templates:

create-project

Creating a project from a template includes exceldna.addin and exceldna.integration packages, SayHello sample function and XML schemas:

cs-project

vb-project

XML schemas are added to the project only if they are not installed in the global schema cache.

Implementation details:

  1. To detect installed schemas at runtime, I've implemented IWizard project creation interface. We can add UI to it to offer project creation options.

  2. I haven't found any API to check installed schemas and just check corresponding files existence in the %VSInstallDir%\xml\Schemas directory and the localized directory (like 1033).

  3. The extension includes specific versions of exceldna.addin.1.1.1.nupkg and exceldna.integration.1.1.0.nupkg. Documentation says it is the best practice: "This prevents package updates from breaking the template, leaving the choice to update the package to the developer using the template."
    https://docs.microsoft.com/en-us/nuget/visual-studio-extensibility/visual-studio-templates